You can use indirect to make the workbook a parameter which you can put
into cell A1. then you only have to change the book name in cell A1 and
all the formulas will automatically reference the new workbook.
From
=VLOOKUP(K29;'C:\Data.xls]Data'!$A$5:$Z$568;12;FALSE)
to
Cell A1 : C:\Data.xls
=VLOOKUP(K29;indirect(A1&"Data!$A$5:$Z$568";12;FAL SE)
--
joel
------------------------------------------------------------------------
joel's Profile:
http://www.thecodecage.com/forumz/member.php?userid=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=158752
Microsoft Office Help