This looks more like a database program than like a spreadsheet. As is said, Excel is a poor man's database. The basic question: are you poor enough to have to do this.
Or are there resources to have a real database program? If it's a one man job (or even a 4 man job) MS Access (part of MS Office) would be fine.
The main table would be:
job - person - date from - date to
referring to a job table and a person table. This should contain the current data, but can contain historic data and future schedules also.
The basic forms would be:
- job maintenance
- person maintenance, including a link to a job
And there should be an option to 'shuffle' persons across jobs every two weeks according to some rules or manually.
Kees
I administer a program in which a large group of people cycle through a set of jobs over the period of a year (in two-week blocks). I'd like to create a condtionally formatted excel workbook with split sheets such that sheet A shows the jobs (arranged by dates in columns and people in rows) and the other shows the people (arranged by dates in columns and jobs in rows), such that if you click on a particular job on sheet A, the workbook will highlight the person working that job on sheet B. In other words, I'd like the data from sheet A to become the row headers on sheet B, and vice versa, and for those sheets to be linked such that a change on one automatically updates the other. Any way to do this in excel? I know it would be complicated and can't figure out the steps. THanks!
Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic