View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 99
Default link to other workbook with changing filename

Hi


"David Billigmeier" wrote in message
...
You're close... you need one more function, INDIRECT():

=INDIRECT("'" & L3 & L4 & "'"!$F$38")



.... and don't forget to open acording workbook every time before changing
the entry in L3. INDIRECT works only when the source workbook is open too -
otherwise you get an error.

Arvi Laanemets