Displaying Comments in separate worksheet

's Computer Specifications

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

's Computer Specifications

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

"(E-Mail Removed)" 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
>

's Computer Specifications

http://www.contextures.on.ca/xlcomme...ml#CopyToSheet

Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 11:28:18 -0700 (PDT), (E-Mail Removed) 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Separate worksheet in separate workbook as macro	dranon	Microsoft Excel Discussion	5	3rd May 2009 03:41 AM
copying comments in excel to a separate worksheet	dmars	Microsoft Excel Programming	14	14th Jan 2009 05:59 PM
exporting comments into a separate spreadsheet?	Joe	Microsoft Excel Misc	1	30th May 2008 08:22 PM
comments on separate page	=?Utf-8?B?Q2hpcm9u?=	Microsoft Word New Users	4	21st Sep 2007 10:42 PM
displaying separate documents on separate screens	cheryl	Windows XP Customization	1	21st Jul 2003 05:13 PM