Excel Help

marco_79

Hi

How do I get round this.

I have a list of numbers added up and the result put into a cell using a simple formula. I want the result copied into another cell on a diffirent sheet within the same work book so I can use it in diffirent formulas on that sheet. The figures on the original will change often so I want the result to change on both the sheets all the time.

Thanks

Marco

Chippy_Minton

If I understand you correctly, it's very simple to do this.

Say you have your list of numbers and their sum on Sheet1. To make the sum appear on Sheet2, click the Sheet2 tab, click a cell where you want the sum to appear, press = on the keyboard, click the Sheet1 tab and click the cell containing the sum and press return. The cell formula on Sheet2 now contains a reference to the sum on Sheet1, e.g. 'Sheet1!A10'

marco_79

Exactly what I wanted to do.

This is a big time saver for me, much appreciated.

Excel Newbie

nearlyrich

When you open the second sheet it will say some of the information is dependant on an other excel sheet, do you want to open it click yes ( The exact wording is slightly different but you get the idea, I have had a couple of glasses of wine and it is very late);)

YorkshireBoy

nearlyrich wrote:

When you open the second sheet...I have had a couple of glasses of wine...

Come on, you've had more than a couple nearlyrich...

I want the result copied into another cell on a diffirent sheet within the same work book

Bossyboots

But for future reference, if you copy cells across workbooks you will get a box saying that information in the workbook you have opened is linked to data in another workbook, do you want to update it. You do not need to open the other workbook for the data to update. Just click yes if you do and no if you don't.

Tony_H_3

Chippy_Minton wrote:

If I understand you correctly, it's very simple to do this.

Say you have your list of numbers and their sum on Sheet1. To make the sum appear on Sheet2, click the Sheet2 tab, click a cell where you want the sum to appear, press = on the keyboard, click the Sheet1 tab and click the cell containing the sum and press return. The cell formula on Sheet2 now contains a reference to the sum on Sheet1, e.g. 'Sheet1!A10'

And if you wanted to use that calculation many times you could "Define" a name for that particular cell eg "Calc_01" then whenever you need to use that particular sum of numbers simply type "=Calc_01" in the required cell and press enter.

Poppy9

Bossyboots wrote:

But for future reference, if you copy cells across workbooks you will get a box saying that information in the workbook you have opened is linked to data in another workbook, do you want to update it. You do not need to open the other workbook for the data to update. Just click yes if you do and no if you don't.

I don't get this message where the linked cells are within the same workbook (i.e. sheet 1 and 2) only when it's linked to different spreadsheets.

Bossyboots

Poppy9 wrote:

I don't get this message where the linked cells are within the same workbook (i.e. sheet 1 and 2) only when it's linked to different spreadsheets.

Thats interesting. All my workbooks link to something else so I have never put that one to the test.

nearlyrich

YorkshireBoy wrote:

Come on, you've had more than a couple nearlyrich...

No I really did only have a couple last night YB!:p