Thank you for your response. I need however to leave the original list
entirely viewable and automatically extract out the students and their
comments to another sheet in the workbook for further processing.
kind regards
Molly

" wrote:

It sounds like you want to see the list but only the rows that contain
comments. If this is correct then maybe what you want is to use
AutoFilter.

Select the comments heading then click on Data - Filter - AutoFilter

Click on the down arrow by the comments heading and select the
(NonBlanks) item in the list.