Calendar that auto-populates from a project management tab

Hello all,

New to the forum, so let me introduce myself - my name is Alexander - a Canadian expat living in Australia working for a resources company. I am fairly comfortable in Excel, however this has me stumped and I have made no headway with all my searches on Google.

I have been asked to auto-populate a calendar tab using data from a project management tab in the same spread sheet essentially to ensure we don't double book ourselves. We want the project title to show up in the calendar on the due date (not a date range) and to have it update itself from the project management tab where we will manage our workflow.

To explain:

• We have a project that is due on 30 June 2013 and enter it into the project management tab;
• Said information shows up in the calendar tab on the due date without the need to manually enter the information again (because gosh knows project-based jobs always have a lot of movement for milestone and due dates);
• When a field in the calendar has data, it changes colour (conditional formatting, something I can figure out, but just running through everything); and
• If the due date has to update, we simply change it on the project management tab and that change is reflected in the calendar.

There are a pile of other things I have started in this spread sheet - but what I am focused on is pulling the Project Name from the one tab, to the calendar tab under the appropriate date.

Am I off my rocker to think that this is possible? Or is this something that may be possible?

I'd appreciate if you could let me know either way :-)

Thanks heaps!

// A

I have attached what I have done so far - basically it's pretty... and useless.

Planning.xlsx

Take a look at this.
I have make changes at all orange cells

How many items do you have maximum on one day?

Look at this example if you have 2 items on one day
If you have more items then isert more rows for one day
Then adjust the formula:
First item:

Please Login or Register  to view this content.

Second Item:

Please Login or Register  to view this content.