Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi I want to add a comment to a cell. But the content of the comment box is
actually some text from another worksheet. Can I use a formula/link to display the text instead of copying the text from the source worksheet to the coment box manually? For example, I want to add a comment to cell A1 in Sheet1. The content of the comment box should be the text in cell B1 in Sheet2. The usual formula (=Sheet2!B1) doesnt work here. Thanks for the replies in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
forcing excel to update the Cell Link when copying Combo Boxes | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
I am trying to link based on a text value instead of cell position | Links and Linking in Excel |