Holiday/Sickness chart

I have to compose a chart for the year showing a column of names for
everybody in my company, and then put the various absences in. I was
wondering if I can make a kind of drop down list, or perhaps colour code the
cell depending on the kind of leave taken. It would be based on a monthly
calender so 1-31 would be the columns with the rows showing names and i would
have 12 tabs for each month of the year. Any help would be appreciated.
Many thanks

Hi Jules

Take a look at Debra Dalgliesh's site for easy instruction on creating a
drop down list.
http://www.contextures.com/xlDataVal01.html


--
Regards
Roger Govier
"jules" <[email protected]> wrote in message
news:[email protected]...
>I have to compose a chart for the year showing a column of names for
> everybody in my company, and then put the various absences in. I was
> wondering if I can make a kind of drop down list, or perhaps colour code
> the
> cell depending on the kind of leave taken. It would be based on a
> monthly
> calender so 1-31 would be the columns with the rows showing names and i
> would
> have 12 tabs for each month of the year. Any help would be appreciated.
> Many thanks
>

Thanks for your help. I'll be sure to take a look.
Regards

"Roger Govier" wrote:

> Hi Jules
>
> Take a look at Debra Dalgliesh's site for easy instruction on creating a
> drop down list.
> http://www.contextures.com/xlDataVal01.html
>
>
> --
> Regards
> Roger Govier
> "jules" <[email protected]> wrote in message
> news:[email protected]...
> >I have to compose a chart for the year showing a column of names for
> > everybody in my company, and then put the various absences in. I was
> > wondering if I can make a kind of drop down list, or perhaps colour code
> > the
> > cell depending on the kind of leave taken. It would be based on a
> > monthly
> > calender so 1-31 would be the columns with the rows showing names and i
> > would
> > have 12 tabs for each month of the year. Any help would be appreciated.
> > Many thanks
> >
>
>
>