Automated Marketing Calendar from Activity Sheet.

[edav4394]

Hi guys,

I hope someone can help with this as I have been struggling with this for a week or so.

What I’m trying to do is have marketing activities automatically populate a marketing calendar.

I have attached a sample of what I’m thinking which is as follows:
• Activity to be colour coded for the duration it runs for (between start and end dates) referenced in the activity sheet
• The campaign name on the activity tab to be labelled on the calendar (sheet 1) but also be within the colour coded duration as per above.
• For each activity to be assigned to an owner in the “A” column based on the owner assigned in the activity sheet.

I think it probably needs a macro but is well beyond what I can do in terms of excel.

Thanks,

Ed 

[Pete_UK]

Take a look at this thread:

http://www.excelforum.com/excel-gene...entry-tab.html

and all the others that it points to - should give you some ideas.

Hope this helps.

Pete