Transfer Comments

[Closed]
Report
Posts
2
Registration date
Tuesday August 11, 2015
Status
Member
Last seen
August 11, 2015
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
Hello,

Is it possible to transfer comments from one cell to another on a different sheet or workbook? I am able to transfer the contents of the cell but not the comments. Is there a way, like some sort of formula, to do this?

Any help would be greatly appreciated! :)

1 reply

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Hi Danny,

This can't be done using formula's, but can be done using macro.

The macro can copy the text from the comment and create a comment with that same text in another cell. What can you tell me about source and destination cells. Like move all comments from column A to column B or move comment from A1 to active cell.

Best regards,
Trowa