update record sheet from production sheet

[johncena]

dear friends here i have attached my document.in my document first sheet I'm keeping record about my daily production.second sheet is my production report.what i want to do is production report data should copy to first sheet correct place,for that second sheet column "B" first 6 characters need to mach with sheet one column "M".if it is matched then sheet two same row column "G" values should copy to first sheet column "N".if at that time any values are already there then don't overwrite that values & new values should combined.
ex-
old value = 5
new value = 10
after running macro =5+10
pla any body can make macro for this.it's very big help for me.thanks.

[excelxx]

Hi johncena

I think the following code may provide you with the solution you want.

Please amend accordingly.

Please Login or Register  to view this content.

[johncena]

thanks a very much excelxx your code almost working.pls can make second sheet column "B" first 6 characters match with sheet one column "M" first 6 characters.because sometime it's coming like this.
ex-second sheet column "B" 125464A & first sheet column "M" same number 125464A-B.
that copy values u can do like this.
ex-
if only one value it should like this (=5) without brackets.
if already values are there then (=5+10) without brackets.

[antoka05]

You can try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

[johncena]

dear antoka05 below link has some error....

Please Login or Register  to view this content.

[antoka05]

Ohps, I apologize for that.
Please change row 22 code:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Regards,
Antonio

[johncena]

wow thanks a lot antoka05.just only one problem is there.if first sheet column "M" value only 6 characters then your macro work very well.but it's like this "125465A-B ".is not working.pls make this correct.thanks a lot.

[antoka05]

I changed macro... I hope this runs fine:

Please Login or Register  to view this content.

Regards,
Antonio

[johncena]

thank you very much antoka05.it's 200% working.thanks a lot again.REP+