VBA code to find a match then sort data in order based on two separate columns

[mustacheman]

We are trying to move inventory from one slot to the next, and do them in sequential order to save footsteps. I'm trying to build the worksheet to plan the moves. Some slots don't have exact matches, so if that's the case we just start back at the beginning of the data list. I was trying to create a macro for this to move the data in a new tab, but I'm getting errors stuck in my loop and variables. My other idea was to keep moving a row at a time and then resorting the table each time but then the variable I set up the numbers are changing after the sorting. Can someone please help?

Here's how it would work. If you look at the attached image

Move Row 2 into new tab. Look at column H to see the prior slot number. Go to that slot number on column I on the workbook. Move that row to the new data set tab. Look at H again to see the next slot number and repeat. (So if no match in column H just go back to the top of the data and start over.


From the image you can see I already did it manually the first 10 rows or so. Column H was slot FG14910 and I found it in column I, so moved that to the next row. Then No match for Fd13310 or FD13710. Then I find a match for FD18210 on the 4th row, so thats next item for the 5th row.

Thanks Mustacheman