You can use dynamic named ranges. See he
http://www.ozgrid.com/Excel/DynamicRanges.htm
Dave
--
Brevity is the soul of wit.
"alves" wrote:
Hi everyone,
I am using a vlookup function:
=VLOOKUP(A25,MV_TD_MT_2004!$A:$G,G$2,FALSE)
In this formula will look for the values in spreadsheet MV_TD_MT_2004,
columns $A:$G.
I have 50+ spreadsheets MV_TD_MT_1953 to MV_TD_MT_2006
Is it possible to make the reference to the spreadsheet with the values
in a dynamic way?
I am trying to avoid using VBA on this one.
Thanks in advance.
PA