Pairing Two Pick Orders using VBA

Hi, I'm very new to VBA. I have 100,000 data on excel to crunch but I have no idea how to start.

I'm trying to pair up two different pick orders (assignment # in column A describe different pick orders down the row). Under each assignment, there are different location number (rows & columns that represent aisles in warehouse). The objective of pairing the two orders is to minimize the distance travel and to reduce the need for visiting same aisle multiple times.

I'm thinking of a loop that will sort the data and rank them numerically but I do not know how to do it while every items stay within the group.

Can anyone help me with that? Attached is the sample data that I have.

I think I had oversimplified the actual situation, sorry about that. Here is more like the real case situation.

I have manually sort the actual orders from the left side of the excel sheet and showed how I wanted the result to look like on the right side of the sheet.

I also put on some description to help you better understand the grouping, matching and sorting method that I intended to code using VBA.


I greatly appreciate everyones help.

Originally Posted by mike7952

Can you show us how you would do this manually on another sheet?

Mike, I just attached the new excel sheet that contains more detail description and sample output on the right side of the spreadsheet.

Thank you really appreciate your help

Originally Posted by alansidman

Not sure if the attached is what you are looking for. If yes, then here is what I did. Took about 3 minutes.
Inserted column A and numbered records 1 up.
Sorted table including column A based upon Columns and then rows
Added column E and numbered 1 up.
Resorted this according to Column A.

If needed this can be applied to some VBA.

Thanks alansidman. but i think i need to come out with some code that will help to match and pair the group according to their similar column number. is there any way that i can do that?

really appreciate your help. thanks