require help in creating a calendar from a worksheet on worksheet 2

[sliderxb]

have created an excel worksheet which contains a five week marketing plan. on the second sheet i would like to create a calendar view pulling across the text and background colours from the column b on the first sheet.


on the second sheet, you would run some form of macro which creates a calendar. the calendar always starts on a monday. so on sheet two i would run a macro enter the month and it would pull through the coloured in detail.


i have uploaded the file at


http://www.officefriendly.info/chandoo


it is entitled office_friendly_marketing_template_new.xlsx


would it be better if dates were entered into the date completed column. if anyone could help that would be great.

 

[Faseeh]

Hi sliderxb,


Do you want that you select on the second sheet options like Planned Activity, Date Completed, Owner etc and then the relavent data is displayed or something else.


Faseeh

 

[sliderxb]

i would like the planned activity details displayed on the second worksheet


thanks