O
Oslopelle
I have a workbook containing all worktimes for all employees for the
year designed someting like this
a b c d e
1 date. name time absencecode time2
2 1/1 Eva 14*21 23*23:59
3 2/1 Eva 9*17
the entry for time2 is for those occations when the emplyee takes an
additional shift to the one previously planned.
Does anyone know vba code or some other clever way to get the time2
from e2 copied in the first available empty cell after a specific row
in coloumn c, the date from a1 into the first available cell after a
specific row (like 26598) in coloumn a the name from b1 in the first
available cell after a specific row? so the endresult becomes:
a b c d e
1 date. name time absencecode time2
2 1/1 Eva 14*21 23*23:59
3 2/1 Eva 9*17
26599 1/1 Eva 23*23:59
/Oslopelle
year designed someting like this
a b c d e
1 date. name time absencecode time2
2 1/1 Eva 14*21 23*23:59
3 2/1 Eva 9*17
the entry for time2 is for those occations when the emplyee takes an
additional shift to the one previously planned.
Does anyone know vba code or some other clever way to get the time2
from e2 copied in the first available empty cell after a specific row
in coloumn c, the date from a1 into the first available cell after a
specific row (like 26598) in coloumn a the name from b1 in the first
available cell after a specific row? so the endresult becomes:
a b c d e
1 date. name time absencecode time2
2 1/1 Eva 14*21 23*23:59
3 2/1 Eva 9*17
26599 1/1 Eva 23*23:59
/Oslopelle