Steve Coates
New Member
- Joined
- Sep 20, 2005
- Messages
- 9
My worksheet is a student report consisting of one page per subject. Cells are populated with data from an external source. Some students take 3 subjects and some take 4, so my worksheet has 4 pages.
I want to be able to set the print area according to whether 3 or 4 pages are populated with data. So is it possible to enter something like "IF cell XY99 is empty then print area is [range1], otherwise print area is [range2]"? Currently I don't know whether such a thing is possible in Excel.
Thanks for any suggestions.
Steve
I want to be able to set the print area according to whether 3 or 4 pages are populated with data. So is it possible to enter something like "IF cell XY99 is empty then print area is [range1], otherwise print area is [range2]"? Currently I don't know whether such a thing is possible in Excel.
Thanks for any suggestions.
Steve