| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reference a cell in another document in Excel formulas?
I am trying to create a formaula that references values in another excel
document. Does anyone know ow to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference a cell in another document in Excel formulas?
Try this:-
=[Book2]Sheet1!$A$1 Mike "Aurielle" wrote: I am trying to create a formaula that references values in another excel document. Does anyone know ow to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference a cell in another document in Excel formulas?
one way to verify the format you need is to enter = and then goto the other
workbook and select the cell of interest "Aurielle" wrote: I am trying to create a formaula that references values in another excel document. Does anyone know ow to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reference a cell in another document in Excel formulas?
With both workbooks open.................
In target book type an = sign in a cell. Switch to source wookbook and select a cell. Hit Enter key. A link has been formed. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 06:00:01 -0700, Aurielle wrote: I am trying to create a formaula that references values in another excel document. Does anyone know ow to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change cell reference within formulas | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Reference the document properties in a cell | Excel Worksheet Functions | |||
| Excel: hold a reference to a single cell when copying formulas? | Excel Worksheet Functions | |||
| Excel: hold a reference to a single cell when copying formulas? | Excel Worksheet Functions | |||
Linear Mode
