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

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Copy WS w/ Named Ranges in Excel 2007 0
Creating a Chart on form from selected data in query. 0
Pulling data from another WS 8
Auto Copy Data from one worksheet to another 1
finding data across multiple ws to populate a userform (Need Help) 6
Converting a “Delete Column” Macro to a “Delete Row” Macro 7
Cut from one sheet, paste in another 2

Top