Searching text in excel using macro [Closed]

Report
Posts
1
Registration date
Sunday August 28, 2011
Status
Member
Last seen
August 28, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello

i want to search words in excel using macros.

i have two sheets(sheet1 and sheet2). i have a column,say E, which has 50 text rows. i need to search for these texts in sheet2. the text in sheet2 is in uppercase. and the data can be slightly different (for eg., sheet1 the data would be Cobbs Parkway and in sheet2 it can be COBBS PARKWY or COBBS PRKWY etc).

so please tell me if at all this is possible using macros.. i need it urgently.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Not 100% because not exact match. and it would be complicated too. I would suggest search for fuzzy search on google. I am sure there would be some thing that you can take and use with modification

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!