I have a excel sheet. In which in a cell I have a drop down list of numbers from 1 to 100.
when selected 1 from drop down list it looksup data in other excel sheet in same workbook.
I want to print this page and so on through the list ends in 100.
pls provide a macro code for this to print the list selecting from 1 to 100 in a single command.