Displaying Comments in separate worksheet

[debbiecundill]

I would like to be able to take multiple comments from one worksheet
and display them all in a separate summary workseet. Could anyone
offer any suggestions please?
Thanks

 

[Mike H]

Debbie,

Select all cells and copy them (Edit - Copy)

Select A1 of the destination sheet and then
Edit - Paste Special
Select 'Comments'
Click OK

Mike

 

[Gord Dibben]

http://www.contextures.on.ca/xlcomments03.html#CopyToSheet


Gord Dibben MS Excel MVP