| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
dynamic link
Is there a way to create a dynamic link?
For example if I had a list of Workbook names in column A, and a repective list of links in column B. Is there a way to create one formula that can be copied in Column B that would dynamically change according to Column A? Column A Column B Legal01 =C:\My Documents\[Legal01.xls]Sheet1!$A$1 Legal02 =C:\My Documents\[Legal02.xls]Sheet1!$A$1 Legal03 =C:\My Documents\[Legal03.xls]Sheet1!$A$1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing automatic link | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Threaded Mode
