Auto Print Funtion

G

Grumpy Gramps

I have a daily entry sheet with 8 columns and 8 sheets named pg1, pg2 etc.
When data is entered in the daily sheet that particular column is linked to
the named sheet. Sometimes only 2 or t3 columns are used I.E. data in col.
1 is linked to "Sheet!pg1", data in column 2 linked to "Sheet!pg2" etc.
What I am looking for is a formula (or macro) that will print only those
sheets that have data in them via a formula or macro without having to check
which sheets have data and then using the Ctrl key to hi-lite each tab and
manually choosing "Print". Your help will be greatly appreciated.

Ed
 

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

selecting workbook/sheet 3
Need a Macro 3
Range name copy Macro 1
Match file names listed in column with file names in folder 1
Many sheets, one DB? 1
Match and delete rows on two different sheets from reference numbers 4
Consolidation Table from Different Excel Tabs with Different Format 1
Finding Duplicate Rows & Highlighting them 6

Top