Previous Topic Next Topic

Searching text in excel using macro

Closed
jinuthomas01 Posts 1 Registration date Sunday August 28, 2011 Status Member Last seen August 28, 2011 - Aug 28, 2011 at 08:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2011 at 06:25 AM
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.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 1, 2011 at 06:25 AM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses