Printing sheets based on a cell value

  • Thread starter Thread starter markvi
  • Start date Start date
M

markvi

I have a workbook of about 30 sheets; each sheet has a date in K4, the value
of which varies from sheet to sheet.

I'm hoping for a method to cycle through the workbook and print the pages
for which K4 equals a specific date such as 12/31/09.

I've tried to Name a 3-D selection (K4 on each sheet) without success. I
have cycled through rows on a single sheet before but I don't know how to
cycle through sheets and then look at 1 cell on each. Can anyone help?

Thanks in advance.
 
Back
Top