Hi,

I've got an excel file which has a report on a sheet, but I've created multiple different views of this report because there will be different people in the company who want to see only certain things. Currently, I select the person's name from a simple DV List and a separate vlookup automatically searches that particular person's view according to a default view list for these people. From this I've created a macro to publish that specific sheet which has been tailored for that particular person's view into a PDF format and email it out to them, picking up their own email address from a specific field which also gets populated from a vlookup, once the person is selected from the dropdown list of people's names.

Now, my dilemma is that I would like to create a macro that will automatically select the next person from the dropdown list and cycle through the macro which does the PDF generation and email send out. I would also like this to continue through the list of names from the dropdown list until it reaches a blank and will automatically stop.

I hope I've explained this clearly. Any help is highly appreciated.

Thanks in advance!
Titan