Copying cell comments to another worksheet
 

I have been reviewing a huge workbook and have added a lot of cell comments.
Is there a way to display all of these on another worksheet? I'd need to
know the worksheetname, the cell location and the comment.

Thanks,
Barb Reinhardt

Copying cell comments to another worksheet
 

http://www.cpearson.com/excel/excelM.htm#PrintComments

might be a start. It writes to word instead of another worksheet.

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

I have been reviewing a huge workbook and have added a lot of cell comments.
Is there a way to display all of these on another worksheet? I'd need to
know the worksheetname, the cell location and the comment.

Thanks,
Barb Reinhardt

Copying cell comments to another worksheet
 

Thanks so much. That gets what I need.

"Tom Ogilvy" wrote:

http://www.cpearson.com/excel/excelM.htm#PrintComments

might be a start. It writes to word instead of another worksheet.

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

I have been reviewing a huge workbook and have added a lot of cell comments.
Is there a way to display all of these on another worksheet? I'd need to
know the worksheetname, the cell location and the comment.

Thanks,
Barb Reinhardt

Copying cell comments to another worksheet
 

See Dave's macro to copy to a Sheet
http://www.contextures.com/xlcomment...ml#CopyToSheet


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tom Ogilvy" wrote in message ...
http://www.cpearson.com/excel/excelM.htm#PrintComments

might be a start. It writes to word instead of another worksheet.

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

I have been reviewing a huge workbook and have added a lot of cell comments.
Is there a way to display all of these on another worksheet? I'd need to
know the worksheetname, the cell location and the comment.

Thanks,
Barb Reinhardt