I have been charged with designing an excel workbook to manage our teams
holidays. Our team works from remote locations so I was thinking of designing
a holiday form in excel which could be completed by staff and then emailed to
the manager who would update the master copy.

I was wondering if anyone had any ideas for the design, the master record
must be graphical and you must be able to view at a snapshot who is out of
the office in any month. I was thinking of having one sheet per month with
dates in range b2:af2 and names of staff in range a3:a18.

Then having a data sheet which could list the individual holidays. The month
sheet could then look up this information.

Does this sound like a good design or can anyone think of something better?
Also how would I look up the individual holidays in the data sheet as i would
probably need a 2 way lookup.

TIA