|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 28th, 2004, 04:41 PM
|
|||
|
|||
links to a tab in another spreadsheet by reference to a cell for the tab name
I need to link to a worksheet in another spreadsheet
using a cell to define the work sheet eg ='[RBM Sept 04.xls]"a1"'!B46 - where "a1" is the cell with the reference in it Regards Matthew Smith 
|
|
#2
September 28th, 2004, 04:53 PM
|
|||
|
|||
|
Hi
is the other file closed or open? -- Regards Frank Kabel Frankfurt, Germany "Matthew Smith" schrieb im Newsbeitrag ... I need to link to a worksheet in another spreadsheet using a cell to define the work sheet eg ='[RBM Sept 04.xls]"a1"'!B46 - where "a1" is the cell with the reference in it Regards Matthew Smith
|
|
#3
September 28th, 2004, 05:00 PM
|
|||
|
|||
|
the chances are that it will be closed
-----Original Message----- Hi is the other file closed or open? -- Regards Frank Kabel Frankfurt, Germany "Matthew Smith" schrieb im Newsbeitrag ... I need to link to a worksheet in another spreadsheet using a cell to define the work sheet eg ='[RBM Sept 04.xls]"a1"'!B46 - where "a1" is the cell with the reference in it Regards Matthew Smith .
|
|
#4
September 28th, 2004, 05:12 PM
|
|||
|
|||
|
Hi
see: http://tinyurl.com/2c62u -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... the chances are that it will be closed -----Original Message----- Hi is the other file closed or open? -- Regards Frank Kabel Frankfurt, Germany "Matthew Smith" schrieb im Newsbeitrag ... I need to link to a worksheet in another spreadsheet using a cell to define the work sheet eg ='[RBM Sept 04.xls]"a1"'!B46 - where "a1" is the cell with the reference in it Regards Matthew Smith .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cut and paste without altering cell reference | ski-rdu | Worksheet Functions | 2 | June 16th, 2004 12:18 PM |
| Changable Cell reference | Nigel Graham | Worksheet Functions | 3 | April 28th, 2004 10:47 AM |
| Circular reference error | Linda | New Users | 3 | April 27th, 2004 04:09 AM |
| Do you have what it takes... | darno | Worksheet Functions | 0 | February 22nd, 2004 08:01 PM |
| Cell Row - Last Cell Entry Reference | auntj | Worksheet Functions | 6 | February 8th, 2004 04:26 PM |
Linear Mode
