Populate Calendar View from Data Table

Hello! I'm trying to populate the Master Calendar tab from the data table in the attached. Ideally, each "Event" (column B) will populate in the appropriate cell that matches the Topic (column A) and Date (column C) on the calendar tab. To complicate things further, I'd like to be able to input more than one Event in any given cell. Additionally (and here's where it gets really complicated), I'd like to be able to apply an overall filer of scale (column D) to the calendar view, so that if a scale of 3 is chosen, events only populate that are marked as a 3 or higher.

Thank you for your help!!

Thanks so much for getting back to me! Answers below:


1) Yes, Dates from January and on should be 2018!

2) How many events is a reasonable limit to a singe cell? I'm ok with adding multiple rows to increase the number of events that can be entered within a topic row. I'm also hoping the scale filter will help with this, as events on a scale of 1 or 2 will be requested from the filter view less frequently.

3) That date is an error, It should be 2017.

4) The dates are week beginning (Mon-Sun), but I'm also ok with adding columns so that each day is listed vs. week-of, if that's easier.

Thank you!

Hi There! I just wanted to check on this. Do you think the spreadsheet I'm looking for is doable? Thank you for your help!

I've submitted a number of calendar files to this forum over the years - here's a link to a thread from a few months ago:

https://www.excelforum.com/excel-gen...-projects.html

You will see that it is purely formula-driven (i.e. no macros) and allows your to enter activities or events with date ranges, which then are automatically expanded to individual days. On the Calendar sheet you can select a particular year and month from drop-downs, and up to 10 events per day can be viewed.

Hope this helps.

Pete

Thanks Pete! I was actually reading through that thread before submitting this one. Ultimately, I'm looking for something a little different, as there are 2 key elements missing from the project calendar you created - the first is the filter of topic or category. Rather than just filing each calendar input in an overall calendar, I'd like them to be entered within their respective topics. The second is the concept of scale - Not all events are created equal and I'd like to spreadsheet to be filterable, so that the user can customize their view by level of importance.

Thanks so much for your help!

Alli

Sorry, been a bit busy at work/personal life and haven't had much time to check the forums.

It definitely could be done. Just not through usual methods with your "one cell" approach.

I should have bit of time later this week, if you haven't got solution by then.

Thank you so much! If you have the time and don't mind doing it, I really appreciate it! I completely understand, though, if you don't have the bandwidth! Thanks, Alli

Hmm, one issue I found.

Displaying multiple lines in a single cell will require word wrap to be turned on.
This results in single event being broken into multiple line if event string is longer than what can be fit in cell/column width.

How do you want to treat this?
1. Adjust column width to longest event string (will be consistent, but will have unnecessary white space)
2. Auto-Adjust column width to fit content (each column size will differ)

Other than that, I've got the base code.

Please Login or Register  to view this content.

You are my hero! Let's go with auto-adjust. Thanks!!

Thank you SO much!!! Have a wonderful day!

You are welcome If this solved your issue, please mark the thread as solved, using thread tool found at top of your initial post.