Auto-populate Grid

Hi

I have two excel sheets (Source Data) and (Calendar). I am populating "Source Data" by running a report. I need the Start Date and End dates from "Source Data" to populate the correct date cells on my Calendar Grid.

In addition I need my date cells in the Calendar Grid to consist of merged cell data from "Source Data" so when users view the grid they can see the detail of each entry.

Each row represents a room in a hotel. I am trying to display who is in each room, what date they arrive and what date they depart for any given month.

My sheet would typicaly cover 5 months (December to April).

Thanks for your help!

Duplicate thread

See this one, which has a solution posted:

http://www.excelforum.com/excel-gene...-creation.html