mouse over

[hurstead]

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

[Dave Peterson]

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