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
|