Export dates from macro enabled excel spreadsheet into an excel calendar

[kayleeb]

Hello there,

I have created an excel spreadsheet that has a date picker in one portion that links to another part of the spreadsheet to fill in the dates selected with the date picker. what i would now like to do is take the dates from the linked cells and have them update into some type of calendar that easily displays the dates. it is only a few specific coloums i would like to import to the calandar. can this be done realtivly easily?
any help would be appreciated and thank you in advance to any one who can offer some support here.

Kaylee

[kayleeb]

here is the attachment, I missed that part in the initial post. I would like the dates from the cells that are linked to the date picker to populate into a calendar. eg columns F through M cells 54:75.

thanks again for any help!

[SandraY]

This MS Office Addin app supports just that, that is it can take Excel event data and render it as a calendar in native Excel & Word format:

http://www.wincalendar.com

It also supports many layouts (Monthly / weekly /Schedule / Agenda).