Move and sort groups separated by blank lines

[TODD4400]

Hello all,

I am back again with two new challenges. Rows are sorted by column A "ITEM NUMBER" which vary by name, number of lines each day, and separated by a blank row.

Column H has "ROW LOCATION" that vary from A, B, C, D, E, F, G, H, I, and R with 3 numerical digits following the letter. All R-rows are highlighted in RED.

I need to move "ITEM NUMBER" groups that do not contain an R-row to the top of the sheet.

Then I need to sort all "ITEM NUMBER" groups that do contain an R-row alphabetically so the R-row is always at the bottom.

I tried to record a macro, but doing that does not take into account the number of rows per group that will change each day.

Any ideas?

[Vraag en antwoord]

Can you also show what the expected result is? Empty rows are not really useful if you want to sort something. There is no macro in the sample file.

[TODD4400]

Book 2 is what I need column H to end up like.

Book 3 is my full template with data pasted from a dashboard, none of the macro buttons have been activated yet.

[Vraag en antwoord]

2 files with different data are rather difficult to compare. I don't think the result matches the question. Maybe it works like this:

Please Login or Register  to view this content.

[TODD4400]

Template 3A is the desired result. Template 3B is what I am getting with the VenA macro.

All it did was add an empty line at the top and made it taller.

[Vraag en antwoord]

Do not use empty rows. If you are unfamiliar with currentregion then you should look it up.