Hello, I am not that familiar with VBA/Macros so this might be asking too much.
I have 2 data sheets (sheet 1, sheet 2) with multiple columns that I need to compare and find any items that are not on both sheets. Before I do this I have to "normalize" the data by creating a unique identifier that each sheet can match against. This requires concatenating several columns with certain conditions. First, there's a source column that will define the concatenate rules based on what's listed in the source. I want to use the column title headers instead of column letters, since the data is on different columns on both sheets. But for purposes of this post, I will use letters for simplicity. The below are my requirements:
source 1 - Concatenate B1 + C1
source 2 - Concatenate B1 + C1
source 3 - Concatenate B1 + C1
source 4 - Concatenate B1 + Mid (D1, 7,4) + Right (D1,1)
source 5 - Concatenate B1 + D1 + E1
This will create a unique identifer for each item that I then want to check against both sheets and have non matches as my output. They can be highlighted on same worksheet(s).
After this point, I want to be able to enter text into a description cell based on different criteria.
Is this a feasable macro? What other information is needed? I realize i may have to tweek this so no worries if not correct on first try.
Thank You
Bookmarks