I have a sheet used to enter a unit and quantity. The quantity is then
calculated by the untis and populated on another sheet for forecasting
purposes. The calculated sheet is formatted to print up to 42 rows of data.
This is to account for the data entry sheet using every single unit. Most of
the time all the rows are not used. Since it's formatted to show all units it
will print 3 pages. Many times though there's only data on the first page
but all 3 pages will print. How do I get Excel to only print the first page
versus all three when less data is entered?