Hi Everyone,

Cany anyone help me with writing a simple code to run every worksheet
in my workbook and do a same vlookup?

i.e.

- I have 10 different worksheets in same format (same number of
columns and rows as well)
- Lookup value is always A5 in each sheet
- Lookup range comes from different excel file called "finance.xls",
"Summary" tab column A to B

I am just trying to do 'Vlookup($A$5,'finance'A:B,2,false) in column B
starting from row 1 to row 2200 for every worksheet.

Please help

Thank you for your help in advance.


Regards


James