How to transfer text to an sheet if the cells en range contains a
 

Hi,

I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all
cells in A1:A30 contains a comment but are blank.
How do I automatic get sheet2 to collect all comments and only the comments
from sheet1?
I have tried using the ISTEXT, but it can't be used on a range.

Hope someone can help me, thanks!

How to transfer text to an sheet if the cells en range contains a
 

In sheet1 select cells A1 thru A30 and copy them.
In sheet2 select cell A1 and:

Edit PasteSpecial comments

only the comments will be copied over, not the values in the cells
--
Gary''s Student - gsnu200724


"mia_kit" wrote:

Hi,

I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all
cells in A1:A30 contains a comment but are blank.
How do I automatic get sheet2 to collect all comments and only the comments
from sheet1?
I have tried using the ISTEXT, but it can't be used on a range.

Hope someone can help me, thanks!

How to transfer text to an sheet if the cells en range contains a
 

By "Comments" do you mean those created by InsertComment?

Or just text string in the cells?

If the first, see Debra Dalgleish's site for code.

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

If the second, select A1:A30 and F5SpecialConstantsOK

EditCopy then paste.

Not automatic, but you could record a macro whilst doing this.


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 08:13:05 -0700, mia_kit
wrote:

Hi,

I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all
cells in A1:A30 contains a comment but are blank.
How do I automatic get sheet2 to collect all comments and only the comments
from sheet1?
I have tried using the ISTEXT, but it can't be used on a range.

Hope someone can help me, thanks!