FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hello,
I'm trying to find a way to code VBA to sort a report by two categories, simple enough, but the added wrinkle is that there is an extra row that has to be included with the sort, and it throws everything off.
This is a snippet of the original data:
I'm trying to sort username alphabetically by shift, so the end result should look like this:
The shift order should be 10A, 10B, 12A, and 12B.
If I simply sort by those two categories, of course, this is what happens:
The data is put in an order that renders the report useless, so clearly I need to keep the user data together as a unit while sorting, but I'm at a loss to figure out how.
Does anyone have any suggestions?
I'm trying to find a way to code VBA to sort a report by two categories, simple enough, but the added wrinkle is that there is an extra row that has to be included with the sort, and it throws everything off.
This is a snippet of the original data:
I'm trying to sort username alphabetically by shift, so the end result should look like this:
The shift order should be 10A, 10B, 12A, and 12B.
If I simply sort by those two categories, of course, this is what happens:
The data is put in an order that renders the report useless, so clearly I need to keep the user data together as a unit while sorting, but I'm at a loss to figure out how.
Does anyone have any suggestions?