Macro to change file name in Vlookup formula
neat answer
--
Allllen
"John Coleman" wrote:
Maybe you don't need a macro. Say that the file names begin in row 1 of
column A. Then in B1 enter:
=VLOOKUP($A$10,INDIRECT(CONCATENATE("[",A1,"]Sheet1!$A$1:$B$7")),2,FALSE)
And copy it down 200 times.
HTH
-John Coleman
msdrolf wrote:
I have a vlookup formula in column B:
=VLOOKUP($A$10,[DATA2.xls]Sheet1!$A$1:$B$7,2,FALSE)
I have copied this 200 times to sequential rows in column B to pull data
from 200 other spreadsheets.
Is it possible to have a macro which would replace the file name DATA2.xls
with the file name listed in column A of the same row and continue to do so
until it reaches the end of the column.
Thanks
|