Create a macro to print reports to Adobe PDF using entries in a data validation list

Hi,

I'm new to this forum and VBA and hoping I could get some help....

I created a report in Excel that uses a data validation list that includes 900+ unique IDs. By selecting an ID, the contents of the report update with the relevant data. I would like to create a macro that does the following:

1. Choose the first ID in the data validation list which then populates the report with the unique data.
2. Print the report to its own PDF file that will be saved in a folder I designate, using the unique ID as the file name.
3. Repeat steps 1 & 2 for every unique ID in the data validation list.

I would also like to create a similar macro that prints a report for each of the unique IDs to my networked office printer.

Thanks for your help!

Hi
Can you post a sample of your file so we can see the structure and then we may be able to help you.
Tony