The data to be retrieved is in a different workbook--not just a different
worksheet in the same workbook?
If that's the case...
The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed.
Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
That includes =indirect.ext() that may help you.
Kevin wrote:
Hi there,
I have this situation:
I have 3 tables of data in 3 separate data worksheets (USD, GBP, Euro) in a
workbook data file (Prices). I want to lookup values in one of the 3 data
worksheets where I define the worksheet name (USD, GBP or Euro) in a cell of
my Form worksheet.
How do I define the path of the worksheet (USD, GBP, Euro) that I want to
lookup into in my lookup formula, by just defining the worksheet name in a
particular cell of my Form?
Thank you.
--
Dave Peterson