Transfer Comments

Closed
Danny1235 Posts 2 Registration date Tuesday August 11, 2015 Status Member Last seen August 11, 2015 - Aug 11, 2015 at 09:33 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Aug 13, 2015 at 11:15 AM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Aug 13, 2015 at 11:15 AM
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
0