If your total on sheet1 a1, then on Sheet2 a1 enter the formula below

=Sheet1!A1

"nut4net2" wrote:

how can i put totals of 1 page to the next page for another report. from page
1 to page 2 of a workbook so that i don't have to redo the second report.
sort of like hyperlinks but the info in the cell goes to the second page of a
workbook