Calendar Worsheets - Streamlining...

[bmasella]

I have a workbook that I use to build project calendars...

In the workbook there is a main worksheet that lists in column A a specific Date and in Column B is a short name for a task...

I then have all of the worksheets that follow that are basically each of the months in a year starting with January... each row containing up to 7 days (cells) with one cell for each day of the month... It looks just like a calendar when printed.

What I want to do is streamline the process of getting the information from my first worksheet into each of the month sheets.... I could probably do a VLOOKUP in each of the cells on each of the calendars looking for that specific date on worksheet 1 but that would be 365 formulas for each year and would seem rather labor intensive to get it done...

Do any of you programmers have any idea how I can get my descriptive colum into the correct cell on the calendar pages in my workbook without programming for each cell in the calendar worksheets?

[oldchippy]

Does this previous link help at all?

http://www.excelforum.com/showthread...light=calendar

or this

http://office.microsoft.com/en-us/ex...179621033.aspx

[bmasella]

I reviewed the first link prior to posting and it really doesn't apply with what I am looking for.

The second link is actually what I used to get my 12 individual calendars...on worksheets 2-13 but it doesn't help me in figuring out how to get the data from worksheet 1, to display in the correct cells on worksheets 2-13.

[arthurbr]

What are you trying to obtain ?
If it is a monthly overview of your project, a Pivot Table will do, your master sheet seeming to be well normalized

[bmasella]

What I am ultimately trying to get to is 12 printable calendars (one for each month) that look similar to the Month View in Outlook with each cell (representing one day each) having the tasks and appointments that are due on that date showing... I would enter all of the tasks and appointments on one worksheet (these are standardized... i really just fill in the dates) and then they carry forward to the individual worksheets where needed.

I then print them out and include them in a project binder for the customers to have hard copy.