I have formula in a cell that calculates a total. I also want that total to appear on another sheet without cutting and pasting or retyping it every time. The second sheet is still within the same EXCEL document, it's just on another tab.
2006-08-04 08:58:21 · 2 answers · asked by homer simpson 3 in Computers & Internet ➔ Software
Formula to reference to another worksheet within another workbook is simple. Lets say your total is on sheet 2 but you want it to display on sheet 1.
Formula in Cell A1 on Sheet 1: =Sheet2!A1
Regards
QwertyKPH @ Yahoo
2006-08-04 10:55:26 · answer #1 · answered by qwertykph 4 · 0⤊ 0⤋
Yes, you can group the tabs (pages) so that we can "drill" the formula through to the rest of the pages in the group.
If there is only one formula that you want then you just build a reference into the cell on the next page.
2006-08-04 16:12:25 · answer #2 · answered by ijcoffin 6 · 0⤊ 0⤋