• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy Insert comment

Hi solvers


I have a data in a cell A1 = 23456 with insert comment as north


want to provide a link to another sheet ,where i need both insert comment and data


thanks


Senthilkumar RM
 
This can't be done natively. There are some scripts that can extract the text from comments if you want to go that way, but I think the bigger issue is how you are setting up your data. If the info in the comment is important enough to be needed somewhere else, it should be in a cell of its own (maybe create a "Comments" column?) rather then embedded in a cell.
 
Hi, senthilkumar_rm!

Some stuff using comments:

http://chandoo.org/forums/topic/list-all-comments-with-sheetcell-references

Regards!
 
Back
Top