formula for creating a shift pattern

[l3ights]

Hi Guys, I'm a total newbie and I have followed an on-line tutorial on how to build a employee roster, I have a list of example employees in the
roster and on each month in the employee section I have a drop down box where I can choose the appropriate employee and it will fill in their
clock number etc, etc., but what I want to do is on another pager create a drop down box with the names and then enter a shift pattern for each
person and a start date and then it will fill the roster you with that persons shift.

I know this is a lot to ask but is this possible?

Also can you give my roster the once over to let me know if I need to modify anything?

thanks

[Saarang84]

Hi,

Welcome to the forum.
Can you please give us more details on the details of shift such as the dates / timings, changeover frequency, etc. ?

Note : While uploading workbooks for your requirement, kindly ensure to remove all sheet protection(s) and insensitive data. In this case, you may just upload a copy of the roster sheet alone (where you want the formulas to be coded) with the above details.

[l3ights]

I want to be able to input the 4 days on and 4 days off rota using 12 hr shifts. but also be able to create other shift patterns at the same time for other employees. I have seen something online whet you can input something like +4 for 4 days working and the 0000 for 4 days off.

Is this ok?

[Shalaby]

Hello, i wonder if this thread is closed or still in action!!
i need also to update my shift rotation worksheet to fill the shift pattern every year when i just edit the year, so it can take the shift who ended the previous year ands complete the new year turnover. My rotation schedule is also 4 days with 4 shifts A, B, C and D 12 hrs (DAY shift Nd NIGHT shift)


if any one eady to help just tell me so i can upload my file

[Pete_UK]

@Shalaby

If you read the Forum Rules at the top of the screen you will see that Rule 02 says that you should not try to hijack someone else's thread - rather, you should start your own thread instead, with a link back to this one if you feel it is relevant. You can attach your file to the new thread, as it always helps to be able to see how your data is laid out and what you want to do with it.

Hope this helps.

Pete

[Shalaby]

HI Pete,

I just wanted to save spaces by not adding more posts to the forum!! anyway i already add a new post but i don't know what is wrong with the file attachment it doesn't open. i tried also to attach a print screen of my file but something went wrong as well. ill try again

thanks for help.