Data should automatically get changed

Closed
Atif - Nov 30, 2010 at 05:26 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 7, 2010 at 09:19 AM
Hello,

My question is i want to paste sum added data on other excel sheet so that data automatically make changes when i make value change it automatically change the other values in total.

Thanks

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 7, 2010 at 09:19 AM
Hi Atif,

You just described how formula's in excel behave.

A1 = 1
A2 = 5
A3 = =SUM(A1:A2) result in 6

Change A1 to 5 then the result of formula in A3 automatically changes to 10.

Can you add more info when formulating your question?

Best regards,
Trowa
0