Compare Columns

[kate.middleton1]

Hello Everybody,
Is this possible to change the code which is attached with this thread according to the example workbook which is also attached with this thread. Although this code works find for comparing two columns. The detail is also written in workbook about the desired results.

Please Login or Register  to view this content.

[kate.middleton1]

I dont like to bump thread again. But somebody reply me kindly.

[patel45]

I can't change your macro, but I can try to propose another one

[kate.middleton1]

Yes, it will be better if you make other one. Thanks alot.

[patel45]

Please Login or Register  to view this content.

[kate.middleton1]

Hello Patel.
Thanks alot for your help. This code works fine but it gives only the Value 1 from sheet 2 not the value 2 from sheet 2 to sheet 3 and other thing is that if i change the position of ZWW123 next to other ID for example XYZ123 then is it also possible to add the value1 and value2 of all XYZ123 together and put it infront of ABC456.

[patel45]

Please Login or Register  to view this content.