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
<TBODY>
</TBODY>
Workbook2
<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.
(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.