Need to compare 2 columns and align them next to the match

Done
Thank you

This code retains your existing formats, not sure if you wanted this, also works if numbers in ColA are not consecutive, not sure if you wanted this either.
Code is simpler if these 2 conditions are not required.

Please Login or Register  to view this content.

on second thoughts ...
scripting dictionary is quite fun, but doesn't (didn't) work on a Mac, and not everyone likes it.
you could instead try

Please Login or Register  to view this content.

Hello,
That almost worked, but it moved a lot of the loans that did have a match all the way to the bottom below everything else. I need them all to match up. Columns B-T need to move together and match up to B's match on A's column. They are numbers in both column A & B. Some will be in one and not the other.

Originally Posted by naenightlucky213

Hello,
That almost worked, but it moved a lot of the loans that did have a match all the way to the bottom below everything else. I need them all to match up. Columns B-T need to move together and match up to B's match on A's column. They are numbers in both column A & B. Some will be in one and not the other.

Both of those codes did just as you requested with the data you gave.

If you're using different data, whose layout I can't guess, then perhaps you could post a representative sample.

Hello,
I am not sure why it did not work. But it moved a lot of the invoice numbers. And it also created multiple tabs. I need all of these changes to take place on the same sheet. I will attach column A & B to show you what it did but I will not include the other columns.

Hello,
I really do not understand where the issue with the code is. But it works for some of them but then there is a bundle of them that dont get matched up with their match in Column A. Please see the attachement & scroll all the way to the last row with info in it to see what happened. Those have matches but arent aligned with them.
Thank you again.

Originally Posted by naenightlucky213

Hello,
I really do not understand where the issue with the code is. But it works for some of them but then there is a bundle of them that dont get matched up with their match in Column A. Please see the attachement & scroll all the way to the last row with info in it to see what happened. Those have matches but arent aligned with them.
Thank you again.

OK. Different data setup does make a difference.
Is it something like this?

Please Login or Register  to view this content.

Wonder if the last piece of code by Kalak has worked as I was working on a similar issue and found that I used a different approach.
At a high level the process is
- create a temporary worksheet to hold the results
- using the data worksheet use vlookup iteratively on each row to match A in B
- if a match exists then iteratively use vlookup across the remaining columns
- put he results from the vlookup into the temporary worksheet
- rename the temporary worksheet

I chose this approach for my piece of work because I had such a headache with shifting rows up and down, accidentally overwriting data or not clearing cells.
Below is the attached code and modified to work with your sample dataset that you provided with your first post.
I'm not sure if this is the most efficient method in terms of speed with regards to dictionary vs vlookup, but I guess is depends the size of your dataset.

If you have already found another solution then that is great.

Please Login or Register  to view this content.