Adding Interactive Calendar to an existing workbook

How to you add or create an interactive calendar to an existing workbook? I have searched online and can not find a solution. Copy and pasting does not work and I have not been able to find a formula to work. Please help.

What do you mean by an "interactive calendar"?

Perhaps you should add a sample Excel workbook where you can explain what you want to achieve in more detail - the yellow banner at the top of the screen gives details of how to do this.

Pete

with VBA - link below will take you to one of my recent replies helping a similar inquiry

https://www.excelforum.com/excel-pro...ml#post5433544

I am working in an existing workbook and want to add a sheet with a calendar that will allow me to pick a month and year to view. I can use a template to create this calendar in a new worksheet but can not figure out how to merge it with the existing workbook I am using.

I have done this several times in this forum for other posters, using formulae only. I can't help you, though, without seeing a sample of your data and what you want to do with it.

Pete

Hey Pete, I'm not sure what info from my workbook you would need. All I want to do is open a new sheet in the workbook and create a calendar for viewing future dates and adding notes to it. No other information in the workbook will be linked to the calendar. I just can't figure out how to either down load a calendar template into the workbook or write a series of formulas to create a calendar. Is their a way to down load an existing calendar template into an existing workbook. Every time I try it creates a new separate worksheet.

I have tried to use the move/copy command as well as merge 2 workbooks. Ever time I do any of these I get a #REF! in the cell where the day of the week should be.

The majority of the calendars that I have submitted here have two sheets: one is a list of "events", which have a title and/or description of the event along with its date (could be start and end date if the event lasts more than one day) and maybe a few other parameters, and there is also a calendar sheet which places the event title (automatically) on the appropriate day(s) of the calendar. Drop-downs allow the month and year to be selected, so the calendar is a whole month view with 7 major columns across, one for each day of the week (e.g. Sunday to Saturday, or Monday to Sunday) and up to 6 weeks shown, depending on the length of the month and the starting day. The number of simultaneous events on any one day can vary - I've had 7, 10, 12, 25, and even 100 (selected in batches of 10).

I am prepared to set this up for you if you attach a sample file, which is why I keep asking you for that, as I need to know which columns you are using and I may need to modify your events sheet (i.e. use extra columns) to suit the way the calendar works.

Pete