| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 workbook reference
I am trying to reference a cell in a different workbook, and canoot remember
the format to reference a cell in a separate file. Can anyone help? I have multiple worksheets in each file and spaces in the worksheet names and file names. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 workbook reference
Open both workbooks.
In a cell in destination workbook type an "=" sign Switch to cell in source workbook and hit ENTER key. Excel will show you the proper syntax including the addition of single quotes when spaces in names are encountered. Gord Dibben MS Excel MVP On Sat, 4 Jul 2009 11:52:01 -0700, srm wrote: I am trying to reference a cell in a different workbook, and canoot remember the format to reference a cell in a separate file. Can anyone help? I have multiple worksheets in each file and spaces in the worksheet names and file names. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 workbook reference
Perfect! Thanks for the answer. It's even easier than I remembered.
Steve "Gord Dibben" wrote: Open both workbooks. In a cell in destination workbook type an "=" sign Switch to cell in source workbook and hit ENTER key. Excel will show you the proper syntax including the addition of single quotes when spaces in names are encountered. Gord Dibben MS Excel MVP On Sat, 4 Jul 2009 11:52:01 -0700, srm wrote: I am trying to reference a cell in a different workbook, and canoot remember the format to reference a cell in a separate file. Can anyone help? I have multiple worksheets in each file and spaces in the worksheet names and file names. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Reference Style | Excel Discussion (Misc queries) | |||
| Worksheet X reference MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 - Reference is not valid | Excel Discussion (Misc queries) | |||
| Reference Book For Excel 2007 | Excel Discussion (Misc queries) | |||
| Cross Reference of Excel Workbook | Excel Discussion (Misc queries) | |||
![srm[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
