J
James
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
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