I know that this has been discussed at some point but for the life of me I cannot find a solution to my issue. If someone could help me with this I would appreciated it.
I have 2 spreadsheets in 1 workbook. One tab is named MASTER and the other tab is named WORKSHEET. Both spreadsheets are identically setup with 3 columns titled UPC, Stockcode, Division. What I want to do is match the rows on the worksheet spreadsheet to the master spreadsheet.
The formula or macro needs to take the first row in the worksheet spreadsheet and then look for a match in the master spreadsheet, all 3 columns of data must match exactly when compared to each spreadsheet.
Example
MASTER
UPC STOCKCODE DIVISION
1234567890 123456 KANSAS CITY
2222222222 323232 FORT WORTH
3333333333 414141 OKLAHOMA
WORKSHEET
UPC STOCKCODE DIVISION
1234567890 123456 MEMPHIS
2222222222 323232 FORT WORTH
3333333333 414141 NASHVILLE
Note: In this example there is only one true match where all 3 columns are in the same row.
Basically all I want done is to have the matched rows highlighted or identified in some way on the "WORKSHEET", so as too make them easily identifiable.
Hope that makes sense.
Bookmarks