I could really use some expert assistance on a problem I'm having trying to find a macro to do what I need to do and if anyone could assist, it would be greatly appreciated.
I'm posting this particular problem on this forum, because I've seen a lot of similar solutions to the problem I have posted here already, but not close enough where I can copy the code and make it work for myself.
I have two columns of Part Numbers from two similar indented Bills of Material. These list can be as long as 18K rows. From the top down, I need to go down each of the list and put the matching entries from column A on the same row as the matching entry in column B or vise-versa, (leaving spaces adjacent to non-matches). The kicker here is that the sort order of either column can not change, because that would interfere with the identity of the product structure. Therefore, there will be blank cells next to those Part Numbers that appear only on one Bill of Material. So the only thing that will happen is that things will shift down in each column until there are matching aligning cells in a row. Seems odd, but the whole idea here is that someone can take two BOM’s for similar products and have a side-by-side comparison. The matches will be easy to spot because they will be directly beside each other.
In a nut shell if you were to go back and remove the blank cells from both columns, you would be right back where you started, because the order of each list will still be the same. Again, if someone can help me with this I would certainly appreciate it.
To try and post an example of the data would be too difficult. However, I could provide an example in Excel if someone would like mt to forward it. I don't see how to attach a file here on the forum or I just don't understand how it is done.