Sorting Ascending within spceicified range

Hi Experts

It's me again. I've been trying different alternatives to sort the rows based on Col D per collection.

This is the closest one, yet there are 2 bugs found.

1- Loop and not able to exit when it reaches the last used rows.
It keeps sorting until I press <Esc> to force quitting
2- It's unable to sort where there is only one SKUs per collection
It sort the next collection as well. Sometimes 3 collections sorted.
e.g. Before Run - Row 9, 29, 32, 35, 45....

Here is my code. What's wrong with my code?

Please Login or Register  to view this content.

Expected Result
E.PNG

Before the run
B.PNG

After then run
A.PNG

You have a couple of threads started that you have not responded to.

People take time to read and answer your questions.
Read the answers to your threads and reply.
If the thread is solved mark the thread as solved.

Hey kimfung20,

Excel has these cool pivot table tools that can get you a great answer without needing VBA. See the attached where I removed your blank rows and did a pivot (very close) like you want.

Time to learn Pivot Tables?

Learn Pivot Table Field Settings.xlsx