Dynamic Drop Down Lists

[GILLY1966]

I have 20 employees table 1

Their holiday are in table 2

I have 10 shifts each day, 7 days a week, so 70 shifts per week.

Each employee is limited to 4 shifts in any 7 days.

I want to set up a calendar, that has drop down lists each day based on holidays and rolling shift count.

Dynamic drop down lists - Help?

 

[HighAndWilder]

I have 20 employees table 1

Their holiday are in table 2

I have 10 shifts each day, 7 days a week, so 70 shifts per week.

Each employee is limited to 4 shifts in any 7 days.

I want to set up a calendar, that has drop down lists each day based on holidays and rolling shift count.

Dynamic drop down lists - Help?

Welcome to Mr Excel.

To enable us to help you can you please post some of the data from your Employee and Holidays table using XL2BB.
What are these tables called?

We don't need actual names, 'Name1', 'Name2' will do, but knowing what columns you have will be useful.

Do employees have a staff number or an ID?

Are you looking to have a Userform that will enable you to select a name and a shift considering the 10 shifts per day rule, 4 in 7 rule and holidays?

Upon selection of a name and a shift, this data will need to be saved in a new table on another sheet.

How long in advance do you allocate people to shifts?

Do you need to evenly allocate shifts?