Excel VBA MACRO - Transfer the data from one sheet to another sheet

[fahadalambd]

Hi everyone,

As you can see in the attached screenshots - I have two sheets ("Sheet1" & "Sheet2") in same excel file.

Some items are common in both "Sheet1" and "Sheet2". For example - Pen Paper, Mango, Book & Suger.

Now I need a VBA script which will automatic transfer the "Price of the common items (Pen Paper, Mango, Book & Suger)" from Sheet1 to Sheet2 and vice-versa.

Please help me regarding this. Thanks in advance

 

[Kerryx]

Why do you need VBA when a simple formula will do?

 

[Kerryx]

Book1
	A	B
1	Item	Price
2	Paper	10
3	Pen	15
4	Tulip
5	Apple	5
6	Pear	12
7	Pasta
8	Salt	42
9	Rice	23
Sheet2

Cell Formulas
Range	Formula
B2:B9	B2	=XLOOKUP(A2,Sheet1!A2:A9,Sheet1!B2:B9,"")

 

[fahadalambd]

Sorry for the late reply and many thanks for the answer. It is working now . Huge thanks again :D