I hope you bear with me as I only use excel for shopping lists :)

I want to link a specific row in worksheet 1 to the same in worksheet 2
so that if I mouse over in sheet 1 it shows the row from sheet 2

How do I do this


--
hurstead
------------------------------------------------------------------------
hurstead's Profile: http://www.excelforum.com/member.php...o&userid=31556
View this thread: http://www.excelforum.com/showthread...hreadid=512510

Excel doesn't work like this.

You could put anything you want in a comment to get the mouse over effect or you
can link one cell to another with a formula (and one cell "sends" the value to
the "receiving" cell--it's not a two way street).

='sheet2'!a1
or
=if('sheet2'!a1="","",'sheet2'!a1)

hurstead wrote:

I hope you bear with me as I only use excel for shopping lists :)

I want to link a specific row in worksheet 1 to the same in worksheet 2
so that if I mouse over in sheet 1 it shows the row from sheet 2

How do I do this

--
hurstead
------------------------------------------------------------------------
hurstead's Profile: http://www.excelforum.com/member.php...o&userid=31556
View this thread: http://www.excelforum.com/showthread...hreadid=512510

--

Dave Peterson