I would appreciate if I can get help in creating this macro. I have two workbooks, and want to compare the specific column from 1st workbook, Ex: Column H with next work book, Ex: column A. After comparison highlight the matching cells in 1st workbook.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Compare two columns in different workbook
- Thread starter moorthy24
- Start date
-
- Tags
- macro office365 excel vbs
rondeondo
Active Member
- Joined
- Aug 15, 2012
- Messages
- 255
- Office Version
- 365
- Platform
- Windows
Hi Moorthy
an option is to add a column to the first workbook and put in
then use conditional formatting to highlight where this new column has true. If you want a macro because you want to do this often, you could probably record one.
I do this process quite frequently, it really is very quick.
an option is to add a column to the first workbook and put in
Excel Formula:
=ISNUMBER(MATCH(h1,[wb2.xlsx]Sheet1!$A:$A,0))I do this process quite frequently, it really is very quick.
Upvote
0
