Hi All,

I have a document spread onto 3 worksheets. The first worksheet is 600 rows
and 22 columns and is a report/checklist. In one of the columns are comments
which I need to capture on the third worksheet because they are detailed as
items to be corrected.
I do not want to continually copy the comments from one page to the other
and would like to do this automatically. There is a problem with copy and
paste as the cells are merged into 3 columns on the first sheet but are
single columns on the report sheet ( 3rd sheet)

I need to use either a function or solution to allow the data in the
comments column to generate another list on another worksheet.

Would appreciate some help from Excel specialists..my knowledge is average
but not sure how to deal with this one.

Thanks

Dave