Printing sheets based on a cell value

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print sheets based on cell value 1
Shift Collate sheet 1-20 when printing entire workbook? 0
Cell data entering slow! 0
Find matching cell and return value of a different cell 5
Hide Co9lumns based on cell value 6
Macro to Format Multiple Sheets based on "Master" Format 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy cell value from one worksheet to matching worksheet in another workbook 4

Top