Oct 15 2022 07:58 AM
Novice here.
Trying to create a calendar for employee schedule that looks like below.
1. Employee selects a date on the Date Picker cell.
2. Dates under the Day of the week changes based on the date picked.
3. Their schedule shows up next to their names based on the date picked.
Date Picker | |||||
Monday | Tuesday | Wednesday | Thursday | Friday | |
Dates | 10/1/22 | 10/2/22 | 10/3/22 | 10/4/22 | 10/5/22 |
Employee 1 | Location 1 | Location 3 | Location 12 | Location1 | Location2 |
Employee 2 | Location 12 | Location 31 | Location 12 | Location 7 | Location2 |
Oct 16 2022 06:17 PM
As of this writing you've had over 60 views with no replies. I'm replying only to tell you that I suspect you will get more of a helpful response if you spell out a bit more here, and maybe even attach a copy of whatever workbook you've created so far. I don't think it will be too difficult to create the functionality you describe; however, it's not just a calendar that is needed. You also must be working with a database or table of data of some sort: WHAT does that look like? Because how the calendar will work will very much be a function of what your source data looks like, what it contains, and how it's arrayed.
So please post a copy of your workbook (with real names removed; use something like Disney character names instead). Post it here if you can, but if not here, on OneDrive or GoogleDrive, posting a link here that grants access to your file.