• 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.

Work Calendar

Phoenix12

New Member
Hello,


I need some help improving a work calendar. I have attached the original calendar. The goal is to make the calendar automatic. Essentially, I want to be able to automatically assign a buyer to a shift. When a buyer works on Saturday, they receive a comp day during the week, I would like this to auto populate as well. The funding section of the calendar can be ignored. There are ten buyers.
 

Attachments

  • 2020 Calendar (1).xlsx
    56.4 KB · Views: 12
Hi ,

I doubt that any help will be forthcoming , because the format of the calendar is such.

Secondly , there is no data collected in one place in the workbook ; all it contains is calendars for various months , some of them with some data filled in , some blank.

It may be easier if the data is in the form of a list or table.

Narayan
 
Narayan,

Thank your for your reply. I have attached a crude table. I hope this helps.
 

Attachments

  • buyers.xlsx
    8.7 KB · Views: 9
Back
Top