| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Question about linking to another workbook
I can set a direct link to another workbook called
='[orange.xls]07-27'!$i$20 Is there a way to change it so that the 07-27 equals to whatever is entered in cell a7, for example if 08-20 is entered it goes to workbook orange sheet 08-20 i tried ='[orange.xls]&a7'!$i$20, but that did not work cam someone please help me Thank you! |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Question about linking to another workbook
I would suggest reading Dave Pearson's post:
http://www.microsoft.com/office/comm...b-0d7d86137810 -- -SA "Susan" wrote: I can set a direct link to another workbook called ='[orange.xls]07-27'!$i$20 Is there a way to change it so that the 07-27 equals to whatever is entered in cell a7, for example if 08-20 is entered it goes to workbook orange sheet 08-20 i tried ='[orange.xls]&a7'!$i$20, but that did not work cam someone please help me Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about linking please | Excel Discussion (Misc queries) | |||
| workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
| Linking Master Workbook & subordinate workbook | Excel Discussion (Misc queries) | |||
| Linking question | Excel Discussion (Misc queries) | |||
| Linking Question | Excel Discussion (Misc queries) | |||
Linear Mode
