Add data to calendar from worksheet, Excel 2000-2003
 

Hello,

I have a calendar that I select the month from a drop down and it will
create a calendar. I would like to put a list of data in column a
begining in cell 1 and a list of dates in column b begining in cell 1
each on sheet2. Then I'll need the data when the month is selected in
column a the macro will put that data in the calendar on sheet 1
according to the dates in sheet 2 column b.

I have not found a calendar to work excatly the I need it to so all
help will appreciated.

Sheet2 Data:

COLUMN A COLUMN B
1 HOME 1/3/2006
2 WORK 1/4/2006
3 MEETING 1/6/2006
4 PARTS 2/4/2006
5 ORDERS 3/20/2006

Thank you for your help'
jfcby