Comparing each item in column? to a list in column?, color both cells if same
Good day everyone. I am attempting to create a macro or code that will compare two lists of data to check if the item in list A is mached in list B. Each cell in the list A will be comparred to each cell in list B. If a match is found, both matching cells are colored or moved to another column or sheet to indicate and verify a match. I have attached a file as an example of what I am looking to do. Thank you all in advance.
Sample File.xls
Here is a quick Macro that I think does what you want.
It compares the two columns and highlights the matches in green and also create two new columns with the matched data paired side by side.
JimBobBowie
Sample1.xls
Good afternoon JimBobBowie. Thank you very much for taking the time to look into this for me. It works great. I have found that it is skiping over cells that should be green and I believe that it is because some of the cells in the second column have an extra space at the end of the cell so it is not matching up with a cell in the left column that is the same but does not have that empty space. Do you have an idea how to account for either column having that space and just if the text is an match? Example below. Thank you again.
Last edited by JamesJohnson31; 10-14-2014 at 12:37 PM.
Hi, JamesJohnson31,
any particular reason why you attach a word document in a question posted in an ExcelForum?
Use Trim to skip all leading and trailing blanks in the cells
And I wonder why there´s a lot of Select which isnt necessary at all ´(except for the macro recorder) as well as I would use Find, Worksheet.CountIf or Application.Match instead of a loop.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I attached the word doc to show the output of the script. Apologies if that was bad form. Thank you for your input. I will play with it some more. Thanks again.
Last edited by JamesJohnson31; 10-14-2014 at 02:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks