Automating a calendar
I have 9 coleagues who insert their holiday dates onto separate sheets in an
Excel workbook.(The sheets automatically update - days taken, days left etc.)
I want to access these dates and display them all as coloured bars on a
single summary sheet. over a given year. ( Months on top, Names on Left, and
bars indicating holiday dates in the correct order.)
I have tried MATCH and conditional formatting to some degree but I can't
seem to set range of dates.
Any ideas please
Regrds
Lofty
|