Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do Not Print Blank Sheet
We are a very small division of a huge organization. The huge folks have a
monthly expense report that makes no sense for our division, so I am attempting to mimic their Excel workbook but with expense items that make sense for our division. I have done the spreadsheet and it works out well. Each day is a separate sheet and then there is a master tally sheet that takes expenses from each day and adds them up for a monthly reimbursement total. 34 sheets in total including 31 day sheets, a tally sheet, an itinerary sheet, and a personal data sheet (name, division, month, year, etc.) However, most of our members only have expenses for a few days during the month. We are wasting a LOT of paper printing out sheets that have no expenses. My thought is to take the daily total, and if it is zero then format an unused cell to have a special character IF the day's total is zero or another special character IF the day's total is not zero. For example, if we do an IF command in a heretofore unused cell (say, F52) and examine the days total and put a N (NO print) if the total is zero or a P (Print) if the total is not zero. Now the problem comes. How do you tell Excel DON'T PRINT this page if F52 is N but print this page if F52 is P? ANybody got a quick and dirty way to do this? Remember, most of the members of this division are technotards and have trouble finding the "on" switch. Any command to do this has to be nearly foolproof, providing we don't hire smarter fools. Jim -- "It is the mark of an educated mind to be able to entertain a thought without accepting it." --Aristotle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print preview shows blank sheet | New Users to Excel | |||
print blank sheet | Excel Discussion (Misc queries) | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
HOW DO I PRINT AN A4 SHEET OF A BLANK CHART ? | New Users to Excel | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions |