O
Ola Sigurdh
Hello
I am working on a spreadsheet for a transportation company where they are
writing in everything that each truck is doing everyday. Here is the layout.
Columns D to I is loading and unloading places, weight and so on.
Column
A B C J
Date Starttime Startkm Pay
Row Endtime Endkm
9 1 06:00 10000 100
10 1 17:00 12000 50
11 1 95
12 Totaltime Totalkm Totalpay
13 2 05:30 12000 95
What I try to come up with is some sort of macro that i the first empty row
after a date is counting the time, the mileage and the total pay for the
day. It can be everything from 2 to 15-20 rows everyday. Hope you understand
my question. Today I do it in another sheet, but some would like to have it
this way. The reason I want it this way is because I want it to be easy to
use and minimize the faults.
TIA
Ola Sigurdh
Sweden
I am working on a spreadsheet for a transportation company where they are
writing in everything that each truck is doing everyday. Here is the layout.
Columns D to I is loading and unloading places, weight and so on.
Column
A B C J
Date Starttime Startkm Pay
Row Endtime Endkm
9 1 06:00 10000 100
10 1 17:00 12000 50
11 1 95
12 Totaltime Totalkm Totalpay
13 2 05:30 12000 95
What I try to come up with is some sort of macro that i the first empty row
after a date is counting the time, the mileage and the total pay for the
day. It can be everything from 2 to 15-20 rows everyday. Hope you understand
my question. Today I do it in another sheet, but some would like to have it
this way. The reason I want it this way is because I want it to be easy to
use and minimize the faults.
TIA
Ola Sigurdh
Sweden