| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel worksheets
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel worksheets
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: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel worksheets
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Overview Improvements for Excel Worksheets | Excel Discussion (Misc queries) | |||
| How to Set background color XLM Excel worksheets in Netscape andFirefox browsers | Excel Discussion (Misc queries) | |||
| Appending excel worksheets | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
