Sorting multiple dynamic ranges on a worksheet.

[kyrgan]

Hello everyone,

I have a worksheet that is populated with unsorted information. The ranges can be dynamic, with the starting and ending columns being the same, but the starting row and ending rows can change depending on how many items are posted.

The items are posted in multiple groups, sometimes as few as 2 groups, but can go up to 10. The groups can have up to 60 rows per group. There are always two to three blank rows between the item groups. The items are always 4 columns, PLU, ItemName, Quantity, Value. The import does not alway include the header details.

I would like to sort based on the item name at the moment, but being able to quicksort each column would be handy.

As a bonus, I would like to insert the subtotal the value of each group and insert the total at the bottom in a new group.

I have played with the LastRow and other select functions, but this one is breaking my brain.

Thanks for any assistance.

K.

 

[kyrgan]

I could really use some help with this thread.

I can't find any other site that addresses this issue.

Thanks