How to transfer current data from one sheet to another sheet

Closed
Sanjoangel Posts 2 Registration date Monday 27 October 2014 Status Member Last seen 28 October 2014 - 28 Oct 2014 à 00:00
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Nov 2014 à 12:01
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Oct 2014 à 12:44
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
4 Nov 2014 à 12:01