Population of Excel Calendar from a List - Multiple Entries on One Day

[rzb1hd]

Hi. First I'd like to say I love this site. It has been very helpful to me many times. Unfortunately, this time my problem is unique so I have to post and hope someone can help.

I found a calendar template in Excel 2007 that fits my needs ALMOST. There is a Notes tab in which you list the Date and Item you want posted on the calendar. Each Month of the calendar is on a separate tab. The problem I have is when there are 2 or more items for a given day, this template will only pick up the first. I would like to know if this can be modified to accommodate 2 or more entries for a given date. I am attaching the template with some test data in the Notes tab. Any help you can provide is GREATLY appreciated.

[Pete_UK]

See my post #6 in this thread:

http://www.excelforum.com/excel-prog...html?p=2863227

for a file that will allow you to display up to 7 events per day.

Also, post #2 in the same thread points to another thread which has a later development of the file, with 4 columns of data for each entry, as this is what that OP wanted to do.

In each of these files there is one calendar sheet which displays one month, rather than having 12 sheets for each month - you select the month and year of interest using the drop-downs on that sheet (K3, K4 in the original).

Hope this helps.

Pete

By the way, I don't think your problem is "unique", as I have answered many similar enquiries over the years.

[Max, Singapore]

In Notes, perhaps you could try reducing the source data with duplicated dates to all single dates, with the corresponding notes separated by commas in the same cell. Then clear the source data and paste the reduced data for the template to function as per normal

To reduce the data to single dates, you could run this sub
--------------------

Please Login or Register  to view this content.

[QuiveringPaws]

From the post script, that makes Pete Unique!

[rzb1hd]

Thanks for the quick response. I did receive a template from another post that allows me to have 7 entries on a single day so I think it fits my need. I will refer to this code though in case it doesn't work like I anticipate.

---------- Post added at 04:15 PM ---------- Previous post was at 04:13 PM ----------

Thanks Pete. The template you provided is perfect for my need.

[Pete_UK]

Glad to hear it - thanks for feeding back.

Pete

[Cutter]

@ rzb1hd

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can 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.

[dijkdes]

Could you share the multiple entry template you received? Thank you.

[Pete_UK]

Does the answer in your other post now answer this?

Pete

[dijkdes]

Yes, I found it. Thanks Pete!