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 |
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 |
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 |
All times are GMT +1. The time now is 04:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com