hi,

I need to create a calender in Excel. The requirement goes like this.

I have scheduled jobs for different products for web server monitoring. To give an example, the below table shows how it is.

Product Job name Schedule
AAA 111 daily
BBB 222 biweekly
CCC 333 daily
DDD 444 weekly
EEE 555 Monthly
FFF 666 daily
GGG 777 weekly
HHH 888 biweekly
III 999 daily

I need to have calender in EXCEL. When i click on Jan, it would show me all the jobs on the respective dates. This is simillar like, having meeting invitation on Outlook calender.

If you take an example of above Product AAA, this job fits in for all the days in a month. I want to see the product info, job name in all the days. Simillarly for the product BBB, i want to see the product name on 15th and 30th of each month. Likewise for others.

BTW, i need to have a master input data table, wherein i can change the product name, job name and periodic schedule information. So that i can have a flexibility in maintaining this data.

Thanks for your help on this.
-VIJ