Hi
On one Excel sheet I have it set out to print on 10 sheets of paper. The total figure for all the job costings is in cell G719. Now, 10 pages is the maximum this report is likely to be, however most of the time it could be on less pages. How can I delete the unused pages and still have the total in a fixed cell? I want this total figure to be linked into another spreadsheet.
Thanks