1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Dynamic Calendar with multiple table data

Hi I'm trying to create a single monthly calendar that pulls in data from 4 separate tables.

The tables need to be separated to keep clients that need followed up with 1. Now, 2. 30 days 3. 60 days 4. 90 days.

Is it possible to color coordinate that to the calendar as well? I.e. clients in blue need contacted in 30 days; clients in orange need contacted in 60 days etc.

I've made a dynamic Calendar and can get 1 table of data in the calendar working, but not multiple tables.

Any help would be appreciated! I need to present to my boss Friday morning.

Apologies...this is my first time posting

I tried to add the screenshots to the post, but it kept deleting them. So I added them in the comments.

I would like the 4 tables to add to the calendar. They may be the same names, so that's why I would like to color code according to which table they are from.

submitted by /u/rainbowluck34
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#real-time data collaboration
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#no-code spreadsheet solutions
#real-time collaboration
#Excel alternatives
#Dynamic Calendar
#multiple tables
#monthly calendar