Comments

[User3340]

Is it possible to do a lookup (or index/match, sumproduct, or some derivation) of comments to transfer comments from one worksheet to specific relevant places on another worksheet?

 

[Robert Mika]

Can this be any help for you?

http://www.pcmag.com/article2/0,2817,2130132,00.asp

 

[User3340]

Unfortunately, no. I have a lot of columns and a lot of rows. I need the comments to come directly to the right place. With this method, I would have to have another whole grid.

 

[SamTYler]

How are you deciding which comments to copy? By something in the comment or in the cell?

Same Q for the destination?

 

[User3340]

The comments are in a grid, specific to the intersection point of that particular row (or client) and column (or investment). The data needs to get to another format, which is not a problem using index/match. The problem is that the comments need to get to the alternate format as well, and at this point that is done manually.

 

[SamTYler]

The problem is that the comments need to get to the alternate format as well.

ayep, that's a problem. As you probably know, it's as easy as Range.Coment.Text = "ABC") to set the comment's text.

Reading the text requires

Range.Comment.Shape.TextFrame.Characters[.Text]

See Characters Method and Object