• 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.

comments in excel

R

rmalik

New Member
Dear All,


I am working on excel 2010

I need to copy a cell content to a Comment into another worksheet in

the same cell ref.


sheet1

A1 = apple

A2 = orange


Sheet2 - target

A1 = comment (apple)

A2 = comment (orange)


Also, when I make changes in worksheet 1 it should automatically refect in the comments in worksheet 2.


Thanks in advance
 
@rmailk:

The simplest way of pasting the comments from a cell to other is doing it through paste special option.


First copy the range cells and then select the destination cell and next paste special.


ALT+E+S+C


And regarding the automated update of the comments, I'm not sure if this can really happen. Let the experts of this forum dig into this.


Thanks,

Raja
 
You must log in or register to reply here.
Back
Top