Populate Calendar From List of Dates

Hi,

Can somebody give me some pointers on populating a calendar based on a list of employee absence dates?

The theory is I will populate a list of absences with Name/Date/Type in one worksheet.

In the second worksheet I will populate a calender for the month and plot the absence dates from sheet one into the calendar and display absence types over the month with some conditional formatting. ( see attached example)

I've attached what I'm trying to achieve....would prefer doing this with VBA unless there is a suitable formula style alternative.

Thanks in advance.

Chris

Well a bit of searching the web and I've got the following to populate the calendar. Not sure of the efficiency of the VBA code though - I'll have to work on this.

Any tips for loops/selecting a bunch of rows based on dates?

Please Login or Register  to view this content.