Transfer values from sht1 to sht2(skipping some sht1 values)

[rkayasth]

Hi Gurus'
I have two sheets, sheet1 and sheet2, and I want to compare "desc" of both sheets & then transfer sheet1 & sheet2's common desc's "amt" values to sheet2.
e.g. "a" is common to both sheets so transfer a's amt i.e. "1" to sheet2's "a amt" and so on. Also if there is already an amt present in sheet2 amt field, then add the old and new amt and display just the sum of both amnts.
Attached excel says it all.
P.S. I was trying to build a macro myself but wasnt successfull.

Thanks,
Ravin

[rwgrietveld]

Could use this macro:

Please Login or Register  to view this content.

[rkayasth]

Hi Ricardo,

You are bang on target, but my mistake in giving you the sample sheet.
your macro works perfectly as per the scenario given by me, but I forgot something to add to the 2nd sheet, which I have done now, it just that the "desc" cells have 2 extra chars. preceding them, so how do I change your macro for them.
I tried left & right(), but not quite getting them right..
Attaching the excel again..

[rwgrietveld]

Simple change:

Please Login or Register  to view this content.

[rkayasth]

Perfect Ricardo,
Actually I achieved it using this

Please Login or Register  to view this content.

But your seems to be much simpler...

Thanks for all your timely and accurate help....really appreciate it...

[rkayasth]

Simple change:

Please Login or Register  to view this content.

Hi Ricardo,

Just one more small help...
In the attached excel(yours), I have another long table besides the small(original table), from which also I wanted to compare the values and pick up certain values from next column, and copy / add that value to another sheets value.
I am able to do all this, but there is a small problem.
Actually, I am defining the named range for the long table by selecting the entire column, so the macro a looooooooong time to search, compare & copy /add the values(obviously, it has to search 65K odd rows.), so I want you to modify the attached macro, to define a named range & search till last row of the long table(which may be at row100, or 200 or 300, since the long table is formed dynamically, thru another macro.)

Attaching the excel with modified macro for the long table...

Thanks,
Ravin

[rkayasth]

Ricardo,
Can you please reply to my earlier question?

Thanks,
Ravin