Log In
Register
Home
March 28, 2021
Offline
I have employees on once column and Day on second column
If any employee worked Weekends such as "Thursday, Friday, Saturday".
I want, employees who works on weekends to be restricted till other employees work on weekends. Those employee worked on weekends will work on normal day.
Any suggestion how to do this.
Thanks and regards
Redha
Trusted Members
December 20, 2019
Offline
Not sure i understand, can you post an example workbook?
March 28, 2021
Offline
Thank you so much. Please see attached file..
March 28, 2021
Offline
Any idea how to solve this please..
thanks
VIP
Trusted Members
December 7, 2016
Offline
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.myonlinetraininghu.....ata-format
Have you seen this blog post about reducing data validation list? Could perhaps be an option for you to test.
Br,
Anders
March 28, 2021
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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
March 28, 2021
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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
1 Guest(s)
