meangreen
Board Regular
- Joined
- Jan 29, 2007
- Messages
- 169
I have a template that I have created for others to use. The sheet runs from A1:H1000 (that's 20 pages). Most of the time the user will only put data in the first 5,6,or 7 pages, but the remaining pages contain formulas and formatting. When the sheet is printed, all 20 pages are printed as a result. Is there a way to set the sheet up so that it it only prints the pages that contain data?
There are formulas on every page (they result in "" if not needed) and it is set up to repeat rows 1:4 at the top of every page.
There are formulas on every page (they result in "" if not needed) and it is set up to repeat rows 1:4 at the top of every page.