Forum Discussion
Best way to segregate certain rows into each of their own worksheet from a primary
What would be the best way to take a single worksheet that contains multiple "record types" and copy them into their own worksheet? The idea is to take each record type and create a copy of th...
NotSoFastEddie you can use FILTER to achieve this.
=FILTER(A1:G11,A1:A11="PCODE")
or below using your table references
=FILTER(TBL_Bouquets,TBL_Bouquets[Record Type]="PCODE")Repeat on each sheet for each record type.
You could also use Power Query from Table/Range and simply filter by Record Type then load to corresponding sheet.
- Hey Andrew. Thanks very much for this option. It works great and is simple. I already have another use for it. Thanks again.
