ExcelBanter - Displaying Comments in separate worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Displaying Comments in separate worksheet (https://www.excelbanter.com/excel-programming/411996-displaying-comments-separate-worksheet.html)

[email protected]

Displaying Comments in separate worksheet

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

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

Gord Dibben

Displaying Comments in separate worksheet

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

Gord Dibben MS Excel MVP

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

All times are GMT +1. The time now is 05:33 AM.