| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
refering to other workbooks
I cant seem to get the referance to another workbook sheet right can anyone
help me out............im trying to make a cell = the text in another cell in a diffrent workbook thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
refering to other workbooks
The easiest way is to have both workbooks open. In the destination cell, type
the equal sign, then use the mouse to click to the other workbook and click the source cell. "cjbarron5" wrote: I cant seem to get the referance to another workbook sheet right can anyone help me out............im trying to make a cell = the text in another cell in a diffrent workbook thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
refering to other workbooks
Click in your destination cell, type an equals sign, then click on your
source sheet, then on the source cell in that sheet, and that should put the reference for that sheet and cell after the equals sign. Accept the formula. -- David Biddulph "cjbarron5" wrote in message ... I cant seem to get the referance to another workbook sheet right can anyone help me out............im trying to make a cell = the text in another cell in a diffrent workbook thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refering a cell | Excel Worksheet Functions | |||
| Refering to Cells | Excel Worksheet Functions | |||
| Refering to an empty cell | Excel Discussion (Misc queries) | |||
| Refering cells between worksheets | Excel Worksheet Functions | |||
| Refering to a tab using data from a cell | Excel Worksheet Functions | |||
Hybrid Mode
