• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need a macro to allocate work from home and work from office to a team

hello,
Let me explain the scenario!

Say Team of 10 people and 5 seats are available in office, each member has to come to office 2 days in a week and has to work from home for 3 days a week or other way around, I have attached a excel file for your reference.

Thanks
 

Attachments

  • Hybrid Schedule.xlsx
    13.2 KB · Views: 3
Pattushivu
You seems to miss few rules
... maybe there are still more of those?

Here is one sample ...
Where do You need any macros or so?
 

Attachments

  • Hybrid Schedule.xlsx
    14.8 KB · Views: 3
Back
Top