Good morning all
I am little confused even where to start so ideas to point me would be ideal. I have a shift rota produced (4 teams x2 on each team) day and nights, the rota is separated on separate monthly sheets. Now what I need to try work out on monthly basis when guys are off the shift is covered so there initials are put in on the shift let's say 01/01/2020 days JW covered day shift . I need to figure out or start so a script can scan the cells (specific) if there is text present like there would be for 01/01/2020 saying ,jw, to then insert in new sheet with JW (new column) date , but also to say day shift or night shift? Is this even possible . but as we have 16 engineers must also check and populate accordingly ? Think I am over thinking this. If help can upload a version to try explain what mean?
Thanks in advance on any direction
I am little confused even where to start so ideas to point me would be ideal. I have a shift rota produced (4 teams x2 on each team) day and nights, the rota is separated on separate monthly sheets. Now what I need to try work out on monthly basis when guys are off the shift is covered so there initials are put in on the shift let's say 01/01/2020 days JW covered day shift . I need to figure out or start so a script can scan the cells (specific) if there is text present like there would be for 01/01/2020 saying ,jw, to then insert in new sheet with JW (new column) date , but also to say day shift or night shift? Is this even possible . but as we have 16 engineers must also check and populate accordingly ? Think I am over thinking this. If help can upload a version to try explain what mean?
Thanks in advance on any direction