Combining comments. Can it be done?

[Jack]

Hi
I have multiple sheets. If things out of the ordinary happen a note will be
left under that date. There is a possiblelity of there being notes on more
than one sheet for the same date
What I am hoping can be done is that on one page I can combine all the notes
that have been done for each date for an easy summary of whats happening.

Thanks

 

[Debra Dalgleish]

There's code here to copy comments to another sheet in the workbook:

http://www.contextures.com/xlcomments03.html#CopyToSheet

If the comment is in your date cell, that date would appear in the
"Value" column. You could sort or filter the list of comments by date.