ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print spreadsheets only if date has been typed onto it. (https://www.excelbanter.com/excel-discussion-misc-queries/176876-print-spreadsheets-only-if-date-has-been-typed-onto.html)

Brian

print spreadsheets only if date has been typed onto it.
 
I have a workbook with mulitple identical worksheets for evaluations. 24 to
be exact. Trying to make it easier for the evaluator to use a macro to print
only the worksheets that have been typed on. For example, on one day you
might do 12 evals then on the next day after opening a blank workbook they
might evaluate 20. However there are a total of 24 tabs avaiable.

Brian

print spreadsheets only if date has been typed onto it.
 
SORRY subject shouls read print spreadsheets only if DATA has been typed onti
it

"Brian" wrote:

I have a workbook with mulitple identical worksheets for evaluations. 24 to
be exact. Trying to make it easier for the evaluator to use a macro to print
only the worksheets that have been typed on. For example, on one day you
might do 12 evals then on the next day after opening a blank workbook they
might evaluate 20. However there are a total of 24 tabs avaiable.



All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com