Extract all comments from a spreadsheet

[Kiran Kumar]

Hi there,


I have inserted some comments in a spreadsheet in A10, B11, B15, C25 and so on....


Now, i need to extract all comments in another spreadsheet or in the same spreadsheet at one shot.


If possible let me know a technique to extract(something like - copy & paste) all comments with or without macros, preferable without macros please.


Thanks much for your support on this!

Rds,

Kiran Kumar

 

[oldchippy]

Hi Kiran Kumar,


Welcome to the forum, take a look at this previous Chandoo page


http://chandoo.org/wp/2009/09/03/get-cell-comments/

 

[Luke M]

If you're wanting all comments in one shot, you might try this macro:

http://www.contextures.com/xlcomments03.html#CopyToSheet


I don't think you're going to be able to do this w/o using VB, unless you use the simple "print comments" page setup.

http://www.contextures.com/xlcomments01.html#Printing

 

[Kiran Kumar]

tat works, thax a lot Luke.

 

[Luke M]

No worries, Kiran Kumar, glad to help.