1 Attachment(s)
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.Attachment 30341