Thanks to all who responded to my last question. Here is a challenge.
I have some account data I pull at work:
I am trying to create a VBA code that does the following in a workbook:
Look in Sheet1, column A, each row,
Then look in Sheet2, column A, each row,
And search to see if any of the “words” in the text in Sheet1, column A, each row matches any of the “words” in the text in Sheet2, column A, each row
If there is a match then highlight the cells in Sheet1, column A, each row, in yellow that matches those in Sheet2, column A, each row
Loop.
The trick with this VBA code is that I am NOT searching for exact matches, I am searching for like words within a string of text made up of more than one words and possible characters.
An example of this maybe an account with the name MICHAELS/CVS in Sheet1, column A, and in Sheet2, column A, the account name is DNR/MICHAELS STORES INC/STRATGC PRT
I need a VBA code smart enough to identify that Michaels is on the other sheet and is thus a duplicate. I would be great if this code can identify the duplicate without me specifying to look for Michaels.
I need this for a model I am building at work. I am still new to VBA, so please make this a simple for me as possible. Your help is much appreciated.
I have some account data I pull at work:
I am trying to create a VBA code that does the following in a workbook:
Look in Sheet1, column A, each row,
Then look in Sheet2, column A, each row,
And search to see if any of the “words” in the text in Sheet1, column A, each row matches any of the “words” in the text in Sheet2, column A, each row
If there is a match then highlight the cells in Sheet1, column A, each row, in yellow that matches those in Sheet2, column A, each row
Loop.
The trick with this VBA code is that I am NOT searching for exact matches, I am searching for like words within a string of text made up of more than one words and possible characters.
An example of this maybe an account with the name MICHAELS/CVS in Sheet1, column A, and in Sheet2, column A, the account name is DNR/MICHAELS STORES INC/STRATGC PRT
I need a VBA code smart enough to identify that Michaels is on the other sheet and is thus a duplicate. I would be great if this code can identify the duplicate without me specifying to look for Michaels.
I need this for a model I am building at work. I am still new to VBA, so please make this a simple for me as possible. Your help is much appreciated.