• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

sliderxb

New Member
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.
 
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
 
Back
Top