Compare two workbooks and fetch value from book 2 to book 1

Hello,

Could someone please help with a VBA code to compare "id"(column1) from workbook1 with "keyid" (column1) from workbook 2 and if there is any match then it should copy value from column E (workbook 2) and paste it in column H (workbook 1). If there is no match then it should return value as zero. If there are multiple keyid matches then create an empty row for every additional column E value on the book 1. (For example, if there are 3 matches on key id, the three corresponding values should be pasted one below the other in the column H).

Please let me know for more clarification.

Thanks for the help.

Maybe this

Please Login or Register  to view this content.