Have you thought of turning on the macro recorder while using Autofilter to
filter for and select the rows to copy/paste?

Try it then post back if you have problems.


Gord Dibben MS Excel MVP

On Tue, 8 Jun 2010 09:29:14 -0700 (PDT), Cope wrote:

I'm sure that this is on here somewhere already but I cannot seem to
find it:

I have a database in which each row contains specific data.

I have added a single colunm in front of the data to flag particular
rows to be used in another ws

I want to create a macro to select specific columns of data from the
flagged rows to copy and paste it into a new ws.

Thank you for your assistance.

CDK