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
hide multiple worksheets based on a formula value in one cell 1
Copy cell value from one worksheet to matching worksheet in another workbook 4
Create a Macro to Range Cells, from the contents of another Cell. 1
Rename Sheets based on List 5
Macro to Combine Data from Multiple Sheets with Cell References 4
Changing sheet name based on a cell in another sheet 1
rename sheets(tabs) 10

Top