excel worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 
If your total on sheet1 a1, then on Sheet2 a1 enter the formula below

=Sheet1!A1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy cells in Excel 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Refer cell value as part of formula 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Variable Worksheet Name in Formula 4
Picture Links printing problem - Help! 1
Formula for cell to get information from other worksheets 1
Add Data to Workbook with information from another 1

Back
Top