Printing each data validation option

[thisandthat]

Hi have a sheet that pulls data from a different sheet based on the value used in a drop down menu(data validation)
I'd like to print out each option automatically (there are around a hundred).

What are my options? Am I going down the wrong road with using a list and data validation?

Thanks

[TMS]

Easiest way would be to have a subroutine that just loops through the Data Validation List and prints the sheet(s) out for each of the options.


Regards, TMS