Hi there,
Hoping someone can point me in the right direction
I have a simple employee schedule which is populated manually, I'd like to create a macro to auto populate it based on a list of values.
So ideally the data in the Q3:R6 table will populate the cells in this example D3:L3.
Name value is unique and needs to be looked up in order to populate the times for that particular employee.
Not sure the best way to do it but was thinking on a basic level
If (AND (column B = R3,
Row2 is > Time In,
Row2 is<Time Out)
then copy and paste Job [R3] Text into individual cells,
Otherwise nothing)
The screen shot below may give you a better idea
Kind Regards
Hoping someone can point me in the right direction
I have a simple employee schedule which is populated manually, I'd like to create a macro to auto populate it based on a list of values.
So ideally the data in the Q3:R6 table will populate the cells in this example D3:L3.
Name value is unique and needs to be looked up in order to populate the times for that particular employee.
Not sure the best way to do it but was thinking on a basic level
If (AND (column B = R3,
Row2 is > Time In,
Row2 is<Time Out)
then copy and paste Job [R3] Text into individual cells,
Otherwise nothing)
The screen shot below may give you a better idea
Kind Regards