linking worksheets

[Phil]

How do I easily link all cells from one worksheet to
another?

 

[Frank Kabel]

How do I easily link all cells from one worksheet to
another?

Hi Phil
try the following:
1. Open both worksheets
2. In your target workbook/worksheet enter the sign =
3. Activate your second workbook and choose your cell.
4. Hit ENTER

The formula should look like
='[other workbook]Sheet1!'A1

Frank

 

[Harlan Grove]

How do I easily link all cells from one worksheet to
another?

Worksheets or workbooks? If just worksheets, then if you had, say, worksheets
named Bob, Carole, Ted and Alice, you could define the following names.

FromBobWS
=INDIRECT("'Bob'!RC",0)

FromCaroleWS
=INDIRECT("'Carole'!RC",0)

FromTedWS
=INDIRECT("'Ted'!RC",0)

FromAliceWS
=INDIRECT("'Alice'!RC",0)

Then, if you were in cell X99 in some other worksheet, you could fetch the value
in, say, Bob!X99 just by using the reference FromBobWS. If you wanted the value
from Alice!X99, you could use FromAliceWS.