VBA code to match record and if found then copy a range of cells

[diageminc]

Hello,

Please see the attached image. currently we are doing this manually, but we would like to have a macro or a vba that will do the following:
- find value of B2 book1 in Column B of book2
- if exact match is found then copy cells C2 through D2 of book1 and paste in book2 in the row where the match was found
- repeat until all the records in book1 are done

Thanks a lot
diageminc

 

[Rijnsent]

Hi Diageminc,

• your image is unreadable
• I assume you started writing that VBA yourself, could you please post your code (in code brackets: [CODE=vba][/CODE] )?

Koen

 

[diageminc]

Hi Koen

Thanks for the reply, please see these two tables below, i am trying to match value of Column "ID" in the second table with the value of Column "ID" in the first table and if an exact match is found, then i want to copy the value of Column Category and PRICE from the second table into the first.

I first tried the vlookup method
=VLOOKUP(B2,[Book2.xlsx]Sheet1!$B:$D,3,FALSE)
but the issue is that not all the values are present in second table so the above formula brings up #n/a

I can write the logic but dont know how to put it in code
Find ID of table 2 in table 1 and if an exact match if found then copy values of Column Category and Price from table 2 to the correspoinding row in table 1, repeat for all records in table 2

Many thanks for your help

ITEM	ID	CATEGORY	PRICE
1	101	TOY	14.99
2	102	JEWELRY	15.99
3	103	PET	16.99
4	104	FURNITURE	17.99
5	105	CAR	18.99
6	106	TOY	19.99
7	107	JEWELRY	20.99
8	108	PET	21.99
9	109	FURNTIURE	22.99
10	110	CAR	23.99

ITEM	ID	CATEGORY	PRICE
2	102	ANIMAL	115.99
7	107	NATURE	116.99
8	108	PLANT	117.99
14	121	TECH	118.99