View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sharonm sharonm is offline
external usenet poster
 
Posts: 21
Default Link Cell with Comments

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.