BijanBorazjani
New Member
- Joined
- Oct 22, 2021
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Good Morning,
I have 2 columns with Unit Numbers. One is a local inventory DB and the other is the Internet inventory DB. I need to compare the two columns of data, find if there are any mismatches, and have the unit number that is not matched inserted into a cell. I wouldn't mind using a VBA code if needed.
So to summarize:
A2:A1001 Data Set 1
D2:D1001 Data Set 2
K2:K1001 Unit Number is in Data Set 2 but not Data Set 1
O2:O1001 Unit Number is in Data Set 1 but not Data Set 2
Any help would be greatly appreciated!
I have 2 columns with Unit Numbers. One is a local inventory DB and the other is the Internet inventory DB. I need to compare the two columns of data, find if there are any mismatches, and have the unit number that is not matched inserted into a cell. I wouldn't mind using a VBA code if needed.
So to summarize:
A2:A1001 Data Set 1
D2:D1001 Data Set 2
K2:K1001 Unit Number is in Data Set 2 but not Data Set 1
O2:O1001 Unit Number is in Data Set 1 but not Data Set 2
Any help would be greatly appreciated!