Active Member
June 25, 2016
I have one worksheet with 8 columns and 500 rows of data that describe characteristics of 500 fire hydrants ... ID number, address, lat/long data, etc. I also have a second worksheet laid out as a form to print that info for each hydrant on a separate piece of paper (or IDEALLY each into a separate PDF file, but that may be asking too much).
I need to automate copying data from the cells in the first row into particular cells on the form worksheet, print that form (or create the PDF), then move on to the data in the second row so it replaces the first, and print again. Repeat 500 times.
I have no idea where to begin so any help will be greatly appreciated.
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Hi Wpfreeman
I have created a macro that will generate the PDF you required (you are not asking too much ).
I have modified the FORM to include some formulas to extract the required information.
The file name generated will be the same as the hydrant's ID.
All files will be saved into the same folder as the attachment.
Just click the button.
Hope this helps.
Sunny
1 Guest(s)