change the word acceding to data

**johncena** · 03-10-2010, 12:06 PM

dear friends this is possible or i don't know.here i attach my document.i need like this.my first sheet column "K" data are two type.it's like this..
1254689
125687A-B
I need to compare column "K" first 6 no with sheet two.
if it's not match & column "L" value "not dyed" or "part dyed "then that text's should delete.
if it's not match & column "L" value "part dyed - bal" then that text should "balance".
pls any can make macro for this .thanks.....

**JBeaucaire** · 03-10-2010, 01:15 PM

Text should be replaced in which column? K or L?

**JBeaucaire** · 03-10-2010, 01:30 PM

I see...it's column L. Try this...

**johncena** · 03-11-2010, 03:50 AM

thanks very much JBeaucaire.your understanding 100% correct & your macro also work very well.only the thing is that first sheet column "M" values not only numbers.that's way i ask to check only first 6 character in sheet two.we check all cell value it will not mach with all data & answer also not correct.
ex-first sheet column "M" cell value is 185468A-C, that same no in sheet two like this 185468A, 185458B &185468C
in this case your macro answer not correct.if u can check first 6 character then my problem is solved.

**JBeaucaire** · 03-11-2010, 04:10 AM

Maybe change this line:

Please Login or Register  to view this content.

**johncena** · 03-11-2010, 04:37 AM

thanks u very much JB.u save my 1 hours working time.this help i never forget.your macro is great.thanks a lot again.....rep+ add....

**JBeaucaire** · 03-11-2010, 05:11 AM

Glad to help, as always.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.