Interactive Calendar within the same workbook between two work sheets.

I want to auto populate data from a cell from worksheet 1 to a similar cell in worksheet 2 relative to the DATE I type into worksheet 1. Basically I have a work schedule excel sheet that I input customer data into for installations. I then would like the data to auto populate the calendar in work sheet 2 according to the date.

Hi Curlymojo, I think this will work for you:-

Please Login or Register  to view this content.

I helped someone else with a calendar the other day so I'll post it as well just incase it might help out.
The heading has a drop-down to choose the month and auto arranges the dates in the calendar to match the days.

Hey Beamernsw. That did the trick. I figured out where you were starting the date out. One last question. Why the code =IFERROR(IF(MONTH(G11+1)=MONTH(G11),G11+1,""),"")
on the bottom of the month cells. And Why all on the bottom cells.

It looks to see if the next date (G11+1) is in the same month, if it is add 1 day (e.g. 29th +1 = 30th), if adding a day advances the date to the 1st of the next month (e.g. 31st + 1 = 1st) leave it blank.
If it is the next month and therefore blank, the next cell would've created an error when it tried to add a day hence the iferror part.
As for why that formula is only on the bottom 2 rows... that's the only place where cells could advanced to the next month.

That makes since. You have been a huge help. In a couple of days I am going to implement this to my workbook. If I have any more questions can I persuade you to assist me once again. probably with simple stuff as I am an armature in this field. I promise to keep it quick.

Sure thing, glad to help when I can.
I've been contributing to excel forums for a few months now and I can easily say I've learned about 4 or 5 times more then I knew before coming here. And I still have much much more to learn.
Doing is the best way to learn :D

Here's another calendar, which can list up to 7 activities per day. Just add your dates and events to the Activities sheet in any order, then select the month and year using the drop-downs in cells K3 and K4.

Hope this helps.

Pete