Find Jobs
Hire Freelancers

Excel - VBA to export data to word template

€8-30 EUR

Completed
Posted over 4 years ago

€8-30 EUR

Paid on delivery
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!
Project ID: 20461357

About the project

8 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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-card/?w=f https://www.freelancer.com/projects/visual-basic-for-applications/Connect-Word-Userform/?w=f https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f https://www.freelancer.com/projects/data-entry/add-excel-table-rows-outlook/?w=f https://www.freelancer.com/projects/php/create-outlook-add-rule-shortcut/?w=f https://www.freelancer.com/projects/data-entry/Macro-Copy-Paste-Excel/?w=f https://www.freelancer.com/projects/excel/Convert-Text-file-XML-file/?w=f https://www.freelancer.com/projects/data-entry/excel-expert-19406573/?w=f https://www.freelancer.com/projects/php/create-csv-file-using-parshub/?w=f https://www.freelancer.com/projects/excel/Excel-Spreadsheet-Formula-Add-Sum/?w=f https://www.freelancer.com/projects/excel/Compare-CSV/?w=f https://www.freelancer.com/projects/excel/ascii-excel-converter/?w=f https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f https://www.freelancer.com/projects/visual-basic/Repair-VBA-Problem-Types-don/?w=f https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f https://www.freelancer.com/projects/visual-basic/VBA-Access-Print-Word-PDF/?w=f I have a lots of experiences in Excel, Access and VBA programming Please contact me. Thanks
€30 EUR in 1 day
5.0 (36 reviews)
5.4
5.4
8 freelancers are bidding on average €31 EUR for this job
User Avatar
"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 major in Finance and MARKETING along with 8 years of experience in Sales, Marketing and Advertising. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
€30 EUR in 7 days
4.9 (221 reviews)
6.8
6.8
User Avatar
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 time and with the highest quality! From the Excel and Word programming, of course, familiar. Give me a chance to show what I can do!
€30 EUR in 1 day
5.0 (107 reviews)
6.2
6.2
User Avatar
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 can get the best results. Looking forward to hearing from you. Thanks.
€25 EUR in 1 day
4.8 (10 reviews)
4.2
4.2
User Avatar
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 in 1 day
5.0 (7 reviews)
3.2
3.2
User Avatar
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" and "Perfect". I always complete the project perfectly. Please check my portfolios and reviews. I want to discuss with you in more detail. I will wait for your answer. Thanks.
€30 EUR in 7 days
4.9 (2 reviews)
2.7
2.7
User Avatar
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 Contact me Via Chat Thanks
€66 EUR in 1 day
5.0 (5 reviews)
2.5
2.5

About the client

Flag of LUXEMBOURG
Trier, Luxembourg
5.0
4
Payment method verified
Member since Oct 15, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.