Hi All,
It's been awhile since last post. I had to revisit it and update it. I have been working on this and just need a little help on a line of code.
When a employee goes on leave and a relief employee covers them, i would like the code to find the cell data in "Roster" sheet and put it to the relief employee name. The code below does do what I like it but at moment i have "SW" (shift swap) instead of the employee roster shift. How do I find the cell data in employee on leave from roster and and put it to relief employee?
The
is what I'm having problems with. Any help will be appreciated.
Please see updated file.
Bookmarks