Apply data|filter|autofilter to that column A.
Show the 13-2006 rows
copy those visible rows to the new sheet.

If you need a macro, you could record one when you do it manually.

fascal wrote:

Hi,

I have a workbook where I want to copy data from one sheet to another sheet
based on a columns criteria.

If Worksheet_1, column A has the value 13-2006, I want all the rows that
contain this value to populate the empty Worksheet_2.

How do I write the if statement to make this happen?

Thanks.

--

Dave Peterson