•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Dynamic Calendar with multiple table data
Our take
Creating a dynamic monthly calendar that integrates data from four separate tables is a great way to manage client follow-ups effectively. Each table can represent clients needing contact at different intervals: 1 day, 30 days, 60 days, and 90 days. By color-coding these clients—such as blue for those due in 30 days and orange for 60 days—you can quickly identify priorities at a glance.
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Calendar formatting. Creating a multiple year with automatic fill in based off inputed informationI want to create a calendar for my office, where I can make it once and everyone else can use it. And they understand how to work it I need a calendar where people can request leave time off and by inputting it in one tab it will automatically populate to the correct spot on calendar. I also need to create a weekly calendar that pulls the info from the monthly calendar. If you have any clue how to assist thanks ahead of time submitted by /u/Tx75110 [link] [comments]
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]
- How do I create a table with days in the columns, locations in the rows, and program names and times in the cells?I need to create something like this image, without doing it manually (hopefully). I need the days of the week as headings on the x axis, locations on the y axis, and then program name and time of program in the cells. I've tried using a pivot table, but the values field won't show the text only calculations. There are over 5,300 events, but I need it summarized down to this to give to the marketing team. I would also like to be able to edit with additional notes if needed. Any ideas other than copy and pasting this manually into a grid? https://preview.redd.it/fk7n51pmcdyg1.png?width=768&format=png&auto=webp&s=c995a7b9f596e97036d1821acc4d61553c82fab2 submitted by /u/im_8675309 [link] [comments]
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