Home |
Search |
Today's Posts |
#1
|
|||
|
|||
= cells
How to you get one cell in a workbook to equal another cell in a completely
different workbook? |
#2
|
|||
|
|||
The easiest way.
With both workbooks open, type "=" in the cell you want to contain the reference. Switch to the target workbook and click in the cell that you want to reference. The formula bar will now have something like =[CompletelyDifferent.xls]Sheet1!A1 Type Enter. XL switches back to the first workbook. You can now close the other workbook - XL will then display the path as well as the file name in the reference. Of course, you could type in the reference directly, now that you've seen the format. In article , "Chuck" wrote: How to you get one cell in a workbook to equal another cell in a completely different workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendlines to ignore empty cells | Charts and Charting in Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Averaging only cells with data | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |