Link Cells with Comments

[Guest]

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.

 

[Joerg]

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