Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referencing workbooks
Hi,
It took me a while but I finally figured out how to reference data from one worksheet to another using the ! key. But I can't seem to find how to reference between workbooks. All I need to reference is one cell from each of 14 workbooks. This cell has data collected from 8 worksheets in each workbook (all being different) Hope I've made a bit of sense here. I'm not real sure I know what I've typed ;") Thanks, Ken |
#2
|
|||
|
|||
Ken wrote:
Hi, It took me a while but I finally figured out how to reference data from one worksheet to another using the ! key. But I can't seem to find how to reference between workbooks. All I need to reference is one cell from each of 14 workbooks. This cell has data collected from 8 worksheets in each workbook (all being different) Hope I've made a bit of sense here. I'm not real sure I know what I've typed ;") Thanks, Ken Open all the work books. In the cell you want to link to the other workbooks, type = and then click on the cell in the first workbook, type + and click on the second cell, etc etc. HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not enough memory for large workbooks | Excel Discussion (Misc queries) | |||
Referencing an Entire Sheet | Excel Discussion (Misc queries) | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Workbooks... | Excel Discussion (Misc queries) | |||
References to open/hidden workbooks become hard-coded in formulas - 2003 | Excel Discussion (Misc queries) |