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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 4, 2014 at 12:01 PM