|
Answer» [timestamp=1173309904] :-?
I have an excel spreadsheet that has about 30 sheets. I have separate accounts on each SHEET but often need to see the running balance of each individual sheet. I would LIKE to take the formula from sheet 2, 3, 4 etc and have it show up in sheet 1. This is what I tried:
I want the total AMOUNT on sheet 2 in cell E13 to show up on sheet 1 in cell D1. And WHENEVER I make changes to the totals on sheet 2, cell E13, I would like the new total to automatically show up on sheet 1, cell D1. I went to sheet 1, cell D1 and entered =2!E13 and hit enter and another window popped up browsing my FILES. I'm totally lost as to how to do this.
Help???The formula in cell D1 on Sheet1 should be =Sheet2!E13. One way to enter such formulas is as follows: Click cell D1 on Sheet1 to select it. Hit the = sign. Now, click on the Sheet2 tab and then on cell E13 on Sheet2, and then hit Enter.
|
