Excel Macro - Dynamically Generated Worksheet to PDF
Closed - This job posting has been filled and work has been completed.
We are looking for an experienced Excel Macro/VB programmer to develop a module to complete the following task. We have done our best to describe our needs below, but if you have any questions, please let us know. We will be providing the base, multi-worksheet database in Excel 2010. We have access to Adobe, but we think the 2010 PDF print feature will be simple to use. Macros that cannot be used/replicated on our machine will not be paid. Applications that do not reference "Excel 2010 module" will be immediately disqualified.
We have a multi-worksheet database featuring about 1400 rows and several columns of data. In the first worksheet (called the reports tab) a dropdown is used to fill in data (from the data tab using VLOOKUP) to produce a report. This report can then be PDF'd for our needs.
We need the macro to loop through each dataset and create an individual PDF for each "report". This would wind up generating approximately 1400 PDF reports.