VBA Vlookup different Workbook copy/paste result

[SuperBaby]

Hi,

(sorry for duplicate the Post, I get suggested to change title)

I would like to ask for <ACRONYM title="visual basic for applications">vba</ACRONYM> code to search the given value in another workbook and return the corresponding cell back to the original workbook. Can anyone help please?

Workbook1

	A	B	C
1	AB6675-30	Confirm

<TBODY>
</TBODY>

Workbook2

	A	B	C
1	AB6675-30.3	00001
2	AC53555-25.1	00002

<TBODY>
</TBODY>

I would like to have cell A1 in workbook1 to be searched in column A workbook2 and return value in column B to workbook 1 column C.

Thank you very much.​

 

[ZAX]

Hi Zax,

Yes I understand now, I should put the workbook name as "workbook1.xlsx" full name. Then it works great now. THank you so much. Sorry for my stupid. I am very new with the vba.

You're welcome,and no need to say this,that's why we're here,to help each other!
ZAX