-
Sort range from one empty row to the next empty row Custom
Hello everyone,
I have an Excel spreadsheet where columns A,B;C,D are filled with data.
The first line is empty and should remain empty.
Column B shows the engine model and every time there is an engine change, there is a blank line.
In the photo is line 6.
I now want to sort the first area up to the empty row ascending first by column C then by column A.
Then the area should be taken by the empty row to the next empty line and sorted again by column C and column A ascending.
And so on.
Attach a photo section of my file.
How do I have to write the VBA command, since the lines for sorting can always be of different lengths. Ask for help.
Vielen Dank im Voraus.fd1d09788-unbenannt.jpg
Last edited by Aussiebear; 11-24-2022 at 01:01 PM.
Reason: Convert to English
-
-
wow a lot of thanks to you that is great. This is exactly that what i searched. Regards
-
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules