New to VBA programming. Need to search through a column and 'group' column #2 with col #1

[sdround]

Good evening,

I am currently trying to sort some data for work. I have several columns of data that I need to 'group' together everytime there is a change in the order number. In other words, each time the order number changes I need to group the items that have the same order number.

SCN (order) FSC QTY LOCATION Descr WGT CUB
125970 803750 1 B18D22 C17 12 OUTLET PK5 304 1827
125970 3550320 2 B03C39 KNIT CUFF LEATHER GLVS 272 5933
125970 3580080 1 K01K10 EASY GOING MAXIDRS XXL 1280 22365

Thanks,

SD

[NickyC]

Hi
could you upload a sheet with an example of the "before" and "after" you are trying to achireve
thanks

[sdround]

Sure. One second please

[sdround]

Attachment 184128

Here you go!

Thanks for looking at this!

SD

[NickyC]

Hi
sorry, I'm stiill not sure what you are trying to achieve. What to you mean by "group" the data?

[NickyC]

please ignore the earlier version of this post
is there a reason you can't just use sort?