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.