Drop Down Box and Printing Associated Regional Forms

Hi All,

I have a dropdown box which selects a store (90+), which displays data tables and graphs based on which store is selected. The stores are assigned to 5 Regional Managers and they have to scroll through the list to select their sites to printi each store details (approximately 20 sites each and an 8 page document). I am looking at a macro button for them to click to get all of their site details printed. Playing around with 2 stores, I have come up with the following, but it prints out 2 versions of the same store. I am needing something in the middle to allow me to assign the right stores to each regional manager.

Please Login or Register  to view this content.

'something is needed in here to allow each of the regional managers stores to be printed one after one with the click of a button

Please Login or Register  to view this content.

The way they get there data at the moment is in a PDF Format, but even when recording the macro, selecting site, clicking on the PDF button, nothing happens.

Please Login or Register  to view this content.

Can anyone help?

Regards,
DSL1970

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

You need to click on edit the post. Highlight the code. Click on the # sign in the menu.