Data should automatically get changed

[Closed]
Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
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 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
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