Thread: How to transfer text to an sheet if the cells en range contains a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mia_kit mia_kit is offline
external usenet poster
  
Posts: 1
Default 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!
Reply With QuoteReply With Quote