G
Gary
In column "A" (A1:A20) titled "Employees", there's recorded employee names
as work is done through a weeks time. There are ten different names that
are possible.
In column "B" there are empty cells (B1:B20) titled "Miles". When an
employee logs miles on a day it is registered in column "B" adjacent to
their name. There are only two employees per sheet that will have recorded
miles, although it is not always the same two.
In cell "C1" & "C2" there are empty cells titled "Employee Miles". We
manually record the two employee names that have miles on that particular
sheet in cells "C1" & "C2".
In cell "D1" & "D2" there are empty cells titled "Miles Total". We manually
count the miles each of the two employees have recorded in different cells
in column "B" through a weeks time and type the totals in cells "D1" & "D2".
In the cells in column "C" we wish to have the names automatically appear
based on if that particular name had any mileage recorded in column "B". In
the cells in column "D" we wish to have the totals automatically appear
based on the sum of miles in column "B" for that particular employee.
How may we automate entries in "C1" & "C2" and "D1" & "D2"?
Regards,
Gary
as work is done through a weeks time. There are ten different names that
are possible.
In column "B" there are empty cells (B1:B20) titled "Miles". When an
employee logs miles on a day it is registered in column "B" adjacent to
their name. There are only two employees per sheet that will have recorded
miles, although it is not always the same two.
In cell "C1" & "C2" there are empty cells titled "Employee Miles". We
manually record the two employee names that have miles on that particular
sheet in cells "C1" & "C2".
In cell "D1" & "D2" there are empty cells titled "Miles Total". We manually
count the miles each of the two employees have recorded in different cells
in column "B" through a weeks time and type the totals in cells "D1" & "D2".
In the cells in column "C" we wish to have the names automatically appear
based on if that particular name had any mileage recorded in column "B". In
the cells in column "D" we wish to have the totals automatically appear
based on the sum of miles in column "B" for that particular employee.
How may we automate entries in "C1" & "C2" and "D1" & "D2"?
Regards,
Gary