Shift rota =if? Or ideas . Lost.

mossone

New Member
Joined
Sep 14, 2012
Messages
47
Office Version
  1. 365
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
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

mossone

New Member
Joined
Sep 14, 2012
Messages
47
Office Version
  1. 365
The idea is to check against what payroll have put in when is sent out but think can work that out.and if point in right direction will start something was thinking of if else but couldn't even think how to determine the day or night shift yet
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,127,050
Messages
5,622,414
Members
415,895
Latest member
Akhilesh28

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top