Add Worksheet Events to Calendar XL2003

[bongybo]

First, I was unsuccessful in converting my sample file to HMTL to include here. Sorry!

I have a table which has a DueDate in Column F and a SpecDueDate in Column G. Column C has a ProjectDescription. Actual data begins on Line 3.

I would like to generate a calendar view on a separate worksheet within the file that updates itself as data changes and shows the ProjectDescriptions on the appropriate "DueDate" on a calendar. Monday thru Friday view would be sufficient, but 7 days is OK. If possible, I'd like to generate a second calendar that would populate based on the SpecDueDate.

Potential issues: Some of the date fields will show "LIVE" instead of a date. Some of the date fields will be blank. Those can all be disregarded.

In my search on Mr. Excel I found a similar request that was resolved successfully. It can be found at http://www.mrexcel.com/forum/showthread.php?t=279909. I tried to adapt the VBA code for my particular file, but it didn't work. And, I really never saw where that code was referencing the columns that hold the critical data.

Any help will be appreciated! Be forewarned: I'm a rookie!

Thank you!