Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Change data from sheet1 to sheet2 by formula [Closed]

Report
-
 Trowa -
Hello,

how to change data from sheet1 to sheet2 by formula
Eg :
Sheet1
A B C
1 5 4 =A1+B1
2 1 5 =A2+B2
3 2 6 =A3+B3


Sheet2
A B C
1 (from sheet1)=A1+B1 10 =A1+B1
2 (from sheet1)=A2+B2 5 =A2+B2
3 (from sheet1)=A3+B3 2 =A3+B3

how to link the formula from sheet1 to sheet2, if sheet1 is change the data, autom sheet2 has to change.

Thank You
Raghu

2 replies

Answer 1 / 2

Sorry made a smaal mistake.

Instead of the"=" next to the formulabar I meant the "Fx".
1
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Answer 2 / 2

Hi Raghu,

Even thought I don't follow your calculations (A1+B1 = 1+5 = 10???), I think your are looking for the following:

Add your sheetname with a "!" before the cell in the formulabar, like this:

=Sheet1!A1+Sheet1!B1

This can also easily be done by clicking the "=" next to the formulabar, choosing the SUM function, then select the cell on the first sheet, then select your second cell and the result in the formulabar will be the same.

Hope this is what you meant.

Best regards,
Trowa
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!