Link spreadsheets?
 

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?



--
deniecemg
------------------------------------------------------------------------
deniecemg's Profile: http://www.excelforum.com/member.php...o&userid=36511
View this thread: http://www.excelforum.com/showthread...hreadid=562693

Link spreadsheets?
 

In LIST1 select a cell and InsertHyperlink.

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

Link to any cell you wish on LIST2


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 21:22:04 -0400, deniecemg
wrote:


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?

Link spreadsheets?
 

;)

thank you!


--
deniecemg
------------------------------------------------------------------------
deniecemg's Profile: http://www.excelforum.com/member.php...o&userid=36511
View this thread: http://www.excelforum.com/showthread...hreadid=562693