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 those in this spreadsheet into another. In this example, there would be the main sheet (shown) and 4 new sheets containing each of the rows for a record type. (Pivot table?)
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 those in this spreadsheet into another. In this example, there would be the main sheet (shown) and 4 new sheets containing each of the rows for a record type. (Pivot table?) Read More