;one way is data-filter-autofilter-choose non blanks copy this to some other
cell or some otehr sheet. but the cells where you copy should NOT be in the
same rows as the data.





Husker87 wrote in message
...
I have a column on one spreedsheet with 50 questions. Each question has a
blank cell under it to input comments. I want to copy the only the
questions
that have comments (together with the comments) over to another worksheet.
How can I do this with a macro? Any ideas?