G
Guest
I have inherited a problem. I work with two multiple worksheet workbooks.
The first workbook is the "master" into which data from the second is pulled.
In the formula pasted below, the phrase "Small Growth" is one of forty
distinct worksheet names in the second workbook "expense stats.xls." Each
worksheet is built identically to the other.
=VLOOKUP($A$3,'C:\My Documents\[expense stats.xls]Small
Growth'!$C$2:$G$2000,5,FALSE).
The formula works but the "Small Growth" expression must be manually
changed. I need a way to automate this. The names originate as values in
$T4 of the INPUT worksheet in workbook one (the master).
The first workbook is the "master" into which data from the second is pulled.
In the formula pasted below, the phrase "Small Growth" is one of forty
distinct worksheet names in the second workbook "expense stats.xls." Each
worksheet is built identically to the other.
=VLOOKUP($A$3,'C:\My Documents\[expense stats.xls]Small
Growth'!$C$2:$G$2000,5,FALSE).
The formula works but the "Small Growth" expression must be manually
changed. I need a way to automate this. The names originate as values in
$T4 of the INPUT worksheet in workbook one (the master).