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

Pulling data from another WS 8
copy data from WS to WS in same workbook 5
Converting a “Delete Column” Macro to a “Delete Row” Macro 7
Ws Selection Change Event Code, Copy a Cell problem 3
Change macro to copy variable amount of rows instead of just 1? 14
Copying data from one sheet to another 3
Using a formula to copy data from one worksheet to another 1
Auto Copy Data from one worksheet to another 1

Top