Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print preview shows blank sheet gillygalloo New Users to Excel 3 May 5th 23 03:41 AM
print blank sheet Rider Excel Discussion (Misc queries) 10 July 19th 07 07:00 AM
Print Blank Pgs - Preview margins outside print range dsm Excel Discussion (Misc queries) 0 October 25th 06 06:17 PM
HOW DO I PRINT AN A4 SHEET OF A BLANK CHART ? heather New Users to Excel 2 February 13th 06 08:39 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM


All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"