VBA - help, from Another workbook.

[Mallesh23]

Hi Team,

I want to apply vlook up in workbook (1) which i opened it from D drive. And my data is in workbook 2. (E dRIVE) in sheet1 (column A Only)

In workbook 1 under sheets (1,2,5) in column b of each sheet ,

I want to apply vlookup formula and drag the formula till last row of Column A of each sheets.

I am facing it hard on working on multiple workbook. can someone send the code to deal such type of situation.

This is daily activity, if you provide some code, It will save my lot of time. Thaks

Regards,
Mallesh

 

[oldbrewer]

make a new spreadsheet in your D drive. tools, macro, record macro, now open your workbook in the E drive, then stop the macro. Examine the code - this should give you a start.