Hi,
I am trying to setup an automated roster for work distribution. I have attached a spreadsheet with a basic template.
There are 9 employees and 3 groups of jobs.
First group A is in a sequence 1 to 9. I filled in an example of 4 employees to show how the job is staggered from day to day
Second group is Job B, where only certain employees do the job (6 out of 9 to be exact)
Third group is Job C, again only 7 of 9 do the job.
Distribution among the three groups of jobs is mutually exclusive.
I have no programming experience. And I have very basic excel formula experience. So I'd appreciate if the solution is based on formulae rather than VBA and Macros, so that I can make minor tweaks if necessary, and also expand it to rest of the year.
Thanks.
Bookmarks