LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default Link Cells 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link to a single wksheet in a wkbook that has comments RedRobyn Excel Discussion (Misc queries) 1 June 27th 06 07:40 PM
Any way to link comments (dynamic) to another cell's contents? KR Excel Discussion (Misc queries) 1 June 27th 06 05:06 PM
how can we copy cells comments text and paste to cells שי פלד Excel Discussion (Misc queries) 3 December 12th 05 05:16 AM
Comments in cells Double Excel Worksheet Functions 3 November 14th 05 09:56 PM
Paste Link - Cell Comments get lost Wayne H Excel Worksheet Functions 2 February 26th 05 11:51 PM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"