Compare two sheets and copy data from sheet to another.

[HXIO]

Hi,

There are two sheets from two different workbooks.

I want to compare the 2 workbooks. But I only need to compare column C in the first workbook against column D in the second workbook.

Then if they matches it will then copy whatever is in column A in the first workbook to the other workbook to column U.

I'm not sure if this can be compare but in workbook one col C is something like this "1DR-RB-82903" and in the other workbook is this "1DR-RB-82903(2A-10KT6574F)RB1".

Thanks

[jindon]

Formula in U2

Please Login or Register  to view this content.

[HXIO]

Thanks jindon!

The formula works great.

But is it possible to do this with the code? Because workbook1 will be deleted afterward.

Thanks

[jindon]

Try

Please Login or Register  to view this content.

[HXIO]

Hi jindon,

Thanks for the code it works great.

But I have try this on other workbook with the same format but it didn't work.

I don't quite understand this part of the code

Please Login or Register  to view this content.

And this part.

Please Login or Register  to view this content.

[jindon]

What do you mean by

it didn't work.

You don't have matching data, so it should return blanks.
Anyway, you now have space before (, so change to

Please Login or Register  to view this content.