| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Making path of linked cell dynamic
Hi all, Is there a syntax to make the path of a linked cell dynamic? I値l explain with an example: Cell A1 is linked to another excel file, example.xls, in the folder week 40. So the formula in cell A1: ='C:\week _40_\[example.xls]Blad1'!$A$1 In this formula, I want the value _40_ to be dynamic, and read this value from cell B1. So lets say I put _41_ in to cell B1, the formula in cell A1 should read ='C:\week _41_\[example.xls]Blad1'!$A$1 Any way to go about this? Thanks a lot in advance! Cheers, Chris -- Negentropy ------------------------------------------------------------------------ Negentropy's Profile: http://www.excelforum.com/member.php...o&userid=27525 View this thread: http://www.excelforum.com/showthread...hreadid=470451 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linked cell contents not autofitting row height | Excel Discussion (Misc queries) | |||
| Link a cell to another workbook with a different path | Excel Worksheet Functions | |||
| How can I replace the path of the linked spreadsheet in a cell? | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| dynamic external cell reference | Excel Worksheet Functions | |||
Threaded Mode
