Forum Discussion
How do I populate a worksheet/book from a master list that has thousands of duplicate values?
I need to create a parent/master sheet that populates other sheets, 90 to be exact, based on their 23-24 location. One sheet/book per distinct location. I'd prefer to populate separate workbooks, but...
=FILTER(A4:G11,A4:A11="Location 1")
FILTER should work if i correctly understand what you want to do. FILTER works between sheets as well but for visualisation i've made an example within one worksheet.
You are my hero, thank you!!