How to transfer current data from one sheet to another sheet [Closed]

Report
Posts
2
Registration date
Monday October 27, 2014
Status
Member
Last seen
October 28, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Please refer to the figure below:




My problem is that I want to see in Sheet 2 under column C the updated Odometer reading that I entered in Sheet 1.

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Sanjoangel,

So if I understand you correctly the result for SEF 263 should be 170+44+80=294

Why don't you use SUM at the bottom of each column (or anywhere else) and then refer to that cell in sheet 2.

To do that go to C4 of sheet 2, type =, then select the cell on sheet 1 which you put the SUM formula in and hit enter.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!