Forum Discussion
Populating Schedule based on two Criteria
Hi There - I am working on a master schedule for a camp that will populate two sheets, one that has a full weekly schedule for all groups (this part I've figure out), and the second sheet (or multiple sheets) that will populate the activity schedule.
Essentially, I have a master schedule and want to be able to pull two smaller data subsets from it, one by group, and the other by activity.
I'm open to any and all changes to make this accessible, thank you!
Below is the master schedule with data
My group schedule (I can drag and it will fill in columns, so easy there), Any adjustments to master will repopulate
Art Schedule, for example, that I want to set up to auto fill in, so any adjustment I make in the master schedule will reflect here.
Thanks in advance for any help!
See attached. It includes a very crude example for just the time-slot you show in the first picture.
This one will work on old and new Excel versions.
2 Replies
- Riny_van_EekelenPlatinum Contributor
See attached. It includes a very crude example for just the time-slot you show in the first picture.
This one will work on old and new Excel versions.
- RDroCopper Contributor
This was an amazing solution! It worked exactly as I needed it to - the amount of time you helped me get back is unfathomable, I cannot thank you enough!
This may be pushing the envelope a little, but is there a way to alter the formula to show if there are multiple groups scheduled at the same time?