excel worksheets

N

nut4net2

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
 
M

Marcelo

Hi,

named the cell when you have the total, imagine it is on g34 of your sheet1
and you named at "total_s1" (no quotes)

on the sheet 2 use

=total_s1

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"nut4net2" escreveu:
 
T

Teethless mama

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

=Sheet1!A1
 
Top