drop down linked to calendar

[Nuju17]

Hello Everybody,

Greetings from UAE. I need your support.
I have created a drop-down list to select the according month.
Now I would like to link this drop-down cell to the calendar, e.g. when I select January, automatically 1.1.2015 should be displayed.

Training Calendar.jpg

Thank you already in advance.

[udprocks]

Hi,

Welcome to forum..

Something like this?? have a look .

[Beamernsw]

Hi nuju17, here's another idea.
I wasn't sure if you had the formula to workout what day starts the month so I supplied my idea for that as well.

If you right-click the heading (dropdown list) and select "Format Cells" you'll see the custom number format I used.

Hope it helps.

[Nuju17]

Dear Beamernsw,

Fantastic, exactly what I was looking for!! Thanks for making my life so easy now

[vlady]

Welcome to the forum Nuju. Thank you for joining.

You can mark your thread solved.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

[Beamernsw]

Very glad to help Nuju17.
One other thing that I should have done but didn't think of was to select column A and Format Cells - Special as mmmm.
Looks better in the drop-down list.

[Nuju17]

Calendar.jpgI tried to solve it by myself but I cannot figure it out - once again help please
I want to link the calendar to an overview now:
Table from 1 - 31 and always the calendar content should to be displayed in the first cell. Excel should find the first cell with content in spreadsheet 1 and put it in the cell 1 at spreadsheet 2 and than always the next until the month is over.

[Beamernsw]

I'm not exactly sure what you're asking Nuju17.
The attached file has a Sheet2 with a list of dates and events and I have the calendar looking up that table to find if there is an event for that day and if so print it in the cell.
I'm hoping that if this doesn't answer it might at least help in the right direction
2 problems though, I had to switch your "Name of session" and "Date" columns, and also the calendar will only ever show 1 event for a day.
If you have more than 1 event or session on the same day then this won't work. I'll do something different.
If it's only 1 event per day but you can't switch those columns then I'll make a helper column on your calendar to fix that.