Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


Reply
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
Having comments link to other workbooks Leslie Excel Discussion (Misc queries) 1 June 10th 08 05:36 PM
Link comments vernors Excel Discussion (Misc queries) 2 January 25th 08 05:22 PM
Link excel comments to cells Bhupinder Rayat Excel Worksheet Functions 1 September 11th 07 12:40 PM
Link Cells with Comments sharonm Excel Worksheet Functions 1 March 8th 07 02:40 AM
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 03:53 AM.

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

About Us

"It's about Microsoft Excel"