Excel Comments

[captmanolo]

I need to copy a cell content to a Comment into another worksheet in
the same cell ref.

sheet1
A1 = apple
A2 = orange

Sheet2
A1 = comment (apple)
A2 = comment (orange)

Thanks in advance

 

[Boon]

click on sheet one, A1
highlight the text bar at the top
right click to copy text

Go to sheet 2, A1
right click and insert comment
when the text field pops up, right click to paste copied text.