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

Edgar,

I have just the thing for you. It is a beta add-in, but it's pretty
resilient. You would need to design a data capture form, but that would be
trivial compared to the functionality already in the add-in. If you want a
copy, mail me directly.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Edgar Thoemmes" wrote in message
...

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

An example:
http://www.sulprobil.com/html/vacation_plan.html

HTH,
Bernd