ssinghal
02-01-2007, 07:30 AM
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?
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?