change the word acceding to data
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.....
Last edited by johncena; 03-11-2010 at 05:28 AM.
Text should be replaced in which column? K or L?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
I see...it's column L. Try this...
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
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.
Maybe change this line:
.FormulaR1C1 = "=IF(RC12="""","""", IF(COUNTIF(DyeQueue, LEFT(RC11,6) & ""*"") > 0, RC12, IF(OR(RC12 = ""NOT DYED"", RC12 = ""PART DYED""), """", IF(RC12 = ""PART DYED - BAL"", ""Balance"", RC12))))"
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
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....
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks