Завершено

Excel - VBA to export data to word template

Dear all,

Due to lack of time (and a bit rusty knowledge in the field) I need someone to help me to put together an excel VBA, that is able to export selected range of data to word documents.

I have 10 groups of data with 5 same categories in each group. I need VBA, upon click of a button, to generate 10 separate word documents using the same template as set out in a separate sheet. Data in this sheet will have the data layout 1 (report layout)

I will have one master sheet, + 10 sheets per group of data. VBA should feed from separate sheets per group. Each group sheet should show the data in pre-set template layout 2 (general layout)

Only complication, not all 5 categories will have input. Some will be empty, so I need VBA not to export empty rows. We can achieve it by ensuring only data with input is shown in each of the 10 group sheets.

Example as in master sheet:

Group 1: Oranges

Cat 1: 15

Cat 2: 4

Cat 3: nil

Cat 4: nil

Cat 5: 3

It should show up in the report file called "Oranges" as such:

Cat 1: 15

Cat 2: 4

Cat 5: 3

Obviously there will be more information that I will populate in the sheet, but the engine will be as described above.

If any questions, please ask.

Timeline: ideally asap, but end of the week would work too.

Many thanks!

Квалификация: Excel, Visual Basic, Visual Basic для приложений, Обработка данных, Microsoft Office

Показать больше how to transfer data from excel to word using vba, excel vba write to word document, generate word document from excel macro, importing data from excel to word template, generate word document from excel data, create word document from excel vba, auto populate word document from excel, vba code to copy from excel and paste in word, excel vba look data sheet, excel vba refresh data moves right, export data word excel, excel vba copy data explorer, excel vba post data web site, excel vba create data file, excel vba add data, excel vba import data csv file, excel vba code data web page, excel vba chart data, excel vba copy data internet explorer, excel vba export range text file

О работодателе:
( 4 отзыв(-а, -ов) ) Trier, Luxembourg

ID проекта: #20461357

Поручен:

valor312

VERY EASY FOR ME, I can do it within 1 hour Hi, Nice to meet you. Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Build-appraisal-record-ca Больше

€30 EUR за 1 день
(36 отзывов(-а))
5.4

8 фрилансеров(-а) в среднем готовы выполнить эту работу за €31

Tanmoy236

"I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with maj Больше

€30 EUR за 7 дней(-я)
(221 отзывов(-а))
6.8
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible Больше

€30 EUR за 1 день
(107 отзывов(-а))
6.2
Developer000

Feel fee to contact me forExcel - VBA to export data to word template .Shoot me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the clients.M Больше

€19 EUR за 2 дней(-я)
(15 отзывов(-а))
4.7
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I am perfected in excel, VBA. I can start right now and can help you. If you hire me,i will do my best for your job and you ca Больше

€25 EUR за 1 день
(10 отзывов(-а))
4.2
rashedkhanrubel

Hi, I have understand the project requirement & interested to make auto word creator for this project. Please send a message so we can discuss more & start the project. Thanks.

€15 EUR за 1 день
(7 отзывов(-а))
3.2
fastestJohn

Hello. I have just read your project. https://www.freelancer.com/u/fastestJohn?w=f This is my profile. I am really interested in your project now. Because my skills are suitable for your project. I like the "Fastest" a Больше

€30 EUR за 7 дней(-я)
(2 отзывов(-а))
2.7
zubairitpro

Hi This is Zubair Malik A Microsoft Certified Technology Specialist and Also A Microsoft Office Certified and I worked on VBA Projects and Have Good Experience with that so I can Make this Vba Script for You Kindly Con Больше

€66 EUR за 1 день
(5 отзывов(-а))
2.5