Auto Populating Calendar

Hello everyone,

This is my first post so I'll just get right into my issue. I'm trying to auto-populate an any year calendar from beginning and end date cells located in a separate worksheet. The goal is to use the dates selected from a drop down calendar to automatically block out those dates with the event name on the calendar in a separate worksheet. Any suggestion at all would be appreciated, I've hit a bit of a dead-end.

Thank you for taking the time to read this.

P.s. The any year calendar has already been created along with the drop down calendar, however if need be i can scrap these.

P.p.s. I'm using excel 2007

P.p.p.s. Attached basic version of workbook as requested PTP.xlsm

Hi,
It would be good if you could just attach a sample workbook so we can have a better look at your data.

You can attach a sample workbook by clicking on "Go advanced" below the typing area and then click on the "Paper Clip" icon from the tools above.

Regards

So i dug through the forum, and i have yet to find an answer to this....any help please....