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" wrote in message ... 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" wrote in message ... 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 |
All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com