Pulling specific Data from one WS to another WS based upon 1 criteria

  • Thread starter Thread starter Cope
  • Start date Start date
C

Cope

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
 
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
 
Back
Top