Forum Discussion

RDro's avatar
RDro
Copper Contributor
Mar 24, 2025
Solved

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!

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.

    • RDro's avatar
      RDro
      Copper 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? 

Resources