Loop involving list

[ssinghal]

I have an excel file with a summary page named MONTH and 31 sheets numbered 1 to 31. The 31 sheets have sales data for various locations. On the MONTH sheet, I have created a list named PROPLIST and used Data Validation to create a dropdown for the list. When I choose a property from the dropdown list, that's property's data populates on the rest of the sheet.

Here's what I need to do from here: I would like to be able to either print this sheet for all items in the drop down box or better yet be acble to choose multiple properties and print those. Is this possible?

[Bob Phillips]

You could add an 'All' option and then copy all the data, but if you want multiple selections you will need a combobox, not DV.

[ssinghal]

I want to choose like 5 properties and have it populate each properties individual data and then print 5 pages.

[Bob Phillips]

Then a combobox it is, and just loop round picking the selected items, invoke the copy routine, print, then next.