How to transfer current data from one sheet to another sheet

Closed
Sanjoangel Posts 2 Registration date Monday October 27, 2014 Status Member Last seen October 28, 2014 - Oct 28, 2014 at 08:15 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Nov 4, 2014 at 11:57 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Nov 4, 2014 at 11:57 AM
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
0