Forum Discussion
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 attache...
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.