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...
See the macro in the attached workbook.
I changed the table on the Main sheet to an ordinary range.
HansVogelaar Thanks for the quick response.
I took the VBA and put it into my "official" spreadsheet and ran the macro.
when I run it I receive a failure message on the range sort. Not sure what to do???Line where it died"official" spreadsheetError Received
I initially got that error too.
I had to convert the table in the data to a normal range for the code to work.
- Hans, I am not sure I understand your statement, "convert the table in the data to a normal range", can you provide more context please.
