Macro for printing to pdf from a data validation drop down

[Patlian Johnson]

Hi All

I am new to macros and need some help.

I have created a table in excel for various entities. I use a data validation drop down list to choose the entity. The tables are the same for each entity all that changes is the information based on the entity that is chosen. I want to develop a macro to print to pdf tables for each entity and save them in a folder on my desktop. Basically I would like the macro to do the following:

1. Choose an entity from the validation list (this will populate the tables with information).
2. Select the print area.
3. Print the tables to a PDF file and save to a specific folder calling the file the entity name which is in a cell underneath data validation list.
3. Repeat steps 1, 2 and 3 for every entity in the data validation list.

Please let me know if you need any more information in order to assist. I have uploaded a sample file.

Thanks in advance for your help!! Much appreciated.
__________________________________________________________________

Mod edit : thread moved to appropriate forum !​