Forum Discussion
NotSoFastEddie
Apr 26, 2024Brass Contributor
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
Apr 26, 2024Brass Contributor
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
HansVogelaar
Apr 26, 2024MVP
I initially got that error too.
I had to convert the table in the data to a normal range for the code to work.