match values in columns vba

**dulitul19** · 03-13-2013, 09:35 AM

Hey guys, I need your help for the following. I have two columns. In column A I have certain values that are the same as the values in column B. However, there are some values in column A that are different and nowhere to be found in column B. I need a macro that can match the same values from columns A and B and color them in say rgb(255,0,0). In this way I would know which values are the same in both columns. I want also to stress out that the values are interchanged. In a sense that if both values are the same in the colums it wont be like A1 - B1, A3 - B3, A5 - B5. It might be A1 - B11, A150 - B13

Here's a sample:

Column A Column B
67441059 67441310
67441060 67441211
67441211 67441362
67441310 67441793
67441361 67441601
67441362 67441672
67441447 67441701
67441601 67441742
67441672 67441790
67441701 67441701
67441742 67441790
67441790 67441870
Thank you.

**arlu1201** · 03-13-2013, 09:43 AM

If all the matches are highlighted in the same color, how would you know which match is where?

**dulitul19** · 03-13-2013, 09:49 AM

I need to know whether the values from column A are to be found in column B. That's what I need. Below I highlighted in bold some of cells just as an example.

67441059 67441310
67441060 67441211
67441211 67441362
67441310 67441793
67441361 67441601
67441362 67441672
67441447 67441701
67441601 67441742
67441672 67441790
67441701 67441701
67441742 67441790
67441790 67441870

The best case scenario would be to cut those values in sheet2 with the corresponding values next to each other.

**JOHN H. DAVIS** · 03-13-2013, 10:26 AM

Does this help?

Please Login or Register  to view this content.

**dulitul19** · 03-13-2013, 10:35 AM

Yep, its working. Thank you very much. I forgot about the vlookup. Need to practice more. Thanks again

**arlu1201** · 03-13-2013, 10:55 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.