| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to edit the link?
='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but
I would like to retrieve the value 6227 from cell B1 for this statement instead of manually input the value 6227 into the string. Do you have any suggestion? Thank you for any suggestion Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to edit the link?
you need to build your name with the indirect() function,which accepts text
strings and converts them to a reference.Any other workbook MUST be open -- paul remove nospam for email addy! "Eric" wrote: ='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but I would like to retrieve the value 6227 from cell B1 for this statement instead of manually input the value 6227 into the string. Do you have any suggestion? Thank you for any suggestion Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to edit the link? | Excel Discussion (Misc queries) | |||
| how do i edit link source in whole workbook? | Excel Discussion (Misc queries) | |||
| Link to external link | Excel Worksheet Functions | |||
| Add Permission did not work in "Allow User to Edit Ranges" | Excel Discussion (Misc queries) | |||
| Can't find Edit, links dialogue box to break the link | Excel Discussion (Misc queries) | |||
Hybrid Mode
