Not sure i understand, can you post an example workbook?

Thank you so much. Please see attached file..

Any idea how to solve this please..

thanks

Hello,

I don’t really understand the data layout you have in your sample file, but it will surely be a tricky one for you to accomplish what you want. I do suggest you store the data in an Excel table. https://www.myonlinetraininghub.com/excel-tabular-data-format

Have you seen this blog post about reducing data validation list? Could perhaps be an option for you to test.

Br,
Anders

imagine, you have a List of 7 Employees working from Sun to Sat.

Weekends are Thu, Fri, and Sat.

List 1, There are some of Employees worked on Weekends.

The challenge is, If Employee on List 1 worked on any of Weekends Thu, Fri, and Sat. Than on List 2 they should work on Normal days such as Sun, Mon, Tue, Wed.

Hope its clear now.

Thanks for the help.

Br,

Redha

Hello Redha,

That part was no issue to grasp, but your data layout is.

Some questions:
- Where is the list of all employees?
- In your lists you have nine rows for each list, seven spanning from Sunday to Saturday, plus two extra rows with no week days, what are these extra rows for? I have my guesses, but I might be guessing wrong.
- The numbers in column A, what do they represent? Instead of 95 you start over from 1 again.
- Will you always have these 15 lists or will it grow over time?
- How do you intend this will act? Programmatically (VBA) or manually using drop down lists?

There are more questions than these, but this will be enough for now.

For a drop down list solution, do check out the article I linked to in my previous post.

Br,
Anders

Dear Anders

Thank you so much for the support.

Please see attached file.

The list will grow over the time.

On every list will have 9 employees, 7 of them will be on duty and the other 2 will be on call. once it pull all employee names from master list will continue the remaining list from first employee on master list till we have 9 employees.

Kind regards

Redha 

Hello,

It looks to me that you want an automated solution using VBA. I am not a good coder, so hopefully someone else can assist you further. I am using the Excel app on my tablet for the moment so I can’t see if there is any code, your previous sample file did not contain any code though. How far have you come with writing your code?

Br,
Anders