Excel VBA Automation
- or -
Post a project like this3674
$$
- Posted:
- Proposals: 9
- Remote
- #443922
- Awarded
Advanced Financial Modeler, Business Plan Writer, Investor Pitch Deck, Xero Setup and Migration expert,
Indore
382454827058762192476314659412453429894492569548700
Description
Experience Level: Intermediate
We have a few hundred report packages that we generate every quarter for clients (referred to as 'companies'). Each is based off of a file that is generated through an Excel add on. It takes a template file and builds a report specific to each company. The resulting file will contain 10 sheets. Many of the sheets will look slightly different between companies. Different companies offer different products, which will cause the number of rows on some sheets to vary. The number of columns can also vary. The report generation process will give all of these reports different print ranges as a result. The page breaks are inconsistent and require manual tweaking for presentation. The goal of this VBA project is to automate this process as much as possible. I would like to have a file that somebody can open, update a few inputs, and run VBA that will format the report and generate a PDF for distribution. I'd also like a separate macro on the same sheet that would just produce the PDF reports. This would be useful if we still had to make manual changes to some of the reports. Two files are attached. One is an example of the input file, which would house the VBA. Detailed project requirements are included there. The other file is an example of the report that requires formatting. I tried to provide as much detail as possible but let me know if you need more information.
Michael B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
2 Apr 2014
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies