Link Cells with Comments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sharonm - 07 Mar 2007 21:36 GMT

Hello All,

i have a workbook with 2 worksheets in it. My data is all on the second
sheet. Many of the cells have comments in them. I want to link the data on
the 2nd sheet to the first sheet with the comment included. Does anyone know
how to do this or if this is even possible?

For Example I have in Sheet 2, Cell B6 a value of 125 plus a comment inserted

In Sheet 1, Cell B13, I have "=+Sheet2!B6". But only the value of 125 is
linking and not the comment which I want to show also.

Any help would be appreciated. Thanks.

Reply to this Message

Joerg - 08 Mar 2007 02:40 GMT

Not possible with built-in Excel functionality, but you should take a look
at the custom function proposed by Dave Peterson at
http://groups.google.com/group/microsoft.public.excel.misc/msg/6245f4aef5472469?
dmode=source

Cheers,

Joerg Mochikun

> Hello All,
>
[quoted text clipped - 9 lines]
>
> Any help would be appreciated. Thanks.

Reply to this Message