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
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
-
I have two sheets. The first sheet contains several columns for various vehicles wherein the first column is intended for the dates. Everyday I have to enter the odometer readings of the entire fleet to their corresponding columns, but I want to use the second sheet to see only the updated odometer readings wherein the first column is for the vehicles and the second column is for the updated/current odometer reading. My problem is how to do it? please help.

2 replies

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi Sanjoangel,

Not clear.

So sheet 1 is filled with odometer readings and sheet 2 has the total or average odometer readings? Then are you looking for a formula or ...

What are you looking for?, maybe some small sample data will clarify the unknown.

Best regards,
Trowa
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!