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 12:00 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 - Nov 4, 2014 at 12:01 PM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 523
Oct 28, 2014 at 12:44 PM
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
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 523
Nov 4, 2014 at 12:01 PM
0