Forum Discussion

tfrench4's avatar
tfrench4
Occasional Reader
Nov 09, 2025

How do I propagate info from Master Tab to Other Tabs

I work with a group of retired teachers in Northern New York.  We have a master list, but would like to generate separate lists (tabs) based on counties (sub-councils) of residence.  

I have attached a screenshot showing the general set up.  

Thanks in advance.

 

excel

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Nov 10, 2025

    Are these names of real people in your screenshot? If so please remove the screenshot. Thank you.

    File Attachments | Microsoft Community Hub

    =FILTER(Masterlist,Masterlist[Council]="Monday")

    I'd turn the Masterlist into a dynamic table and apply the FILTER function in the subsheets. I can't attach a sample file therefore i've added a screenshot that shows the result within the same sheet. The formula works across sheets as well. If you don't have access to the FILTER function i can suggest a solution that works in legacy Excel such as Excel 2013.

     

Resources