| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link to other workbook with changing filename
Hi,
I have two helper cells with values: L3 = [Trials AM05 30Aug06.xls] L4 = T AM06 A 30Aug06 usd I am trying to recreate this: ='[Trials AM05 30Aug06.xls]T AM05 A 30Aug06 usd '!$F$38" using: ="'" & L3 & L4 & "'"!$F$38" but it says there's an error. What's wrong with my formula? Any help would be greatly apprciated. Dave. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i edit link source in whole workbook? | Excel Discussion (Misc queries) | |||
| Workbook with phantom link | Links and Linking in Excel | |||
| How do I link to a workbook whose name is variable? | Excel Discussion (Misc queries) | |||
| how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
| Link to password protected workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
