View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Displaying Comments in separate worksheet

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

" wrote:

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