linking worksheets

  • Thread starter Thread starter Phil
  • Start date Start date
Phil said:
How do I easily link all cells from one worksheet to
another?
Click to expand...

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
 
How do I easily link all cells from one worksheet to
another?
Click to expand...

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.
 
Back
Top