Link spreadsheets?

[deniecemg]

Hi - I am sure this can be done, I just can't find where/how to do it.

I have 2 spreadsheets -- LIST1, LIST2

I want a cell in LIST1 to link to a certain cell in LIST2. When you
click on this cell, it actually opens up the LIST2 xls and goes to Cell
A4. (A4 just an example)

Not an external reference where the data from LIST2 shows up in the
cell in LIST1, that is not what I am looking for.

Can you help?
(e-mail address removed)

 

[Gord Dibben]

In LIST1 select a cell and Insert>Hyperlink.

From the options that appear, select a file to link to.

Link to any cell you wish on LIST2


Gord Dibben MS Excel MVP

 

[deniecemg]

thank you