You have chosen to sponsor your bid up to a maximum amount of .
I need to create a means of automatically populating a PDF document (attached) from an excel file.
My excel file will have multiple records vertically and fields horizontally.
I will need to have a drop down function to select the ID of the record for which I want the form populated.
I will need a macro to:
- populate the PDF fields with the relevant information for the chosen record
- create and individual PDF file with the name and date
- Save the PDF file to a predetermined loaction (folder)