Find Value and Move Rows to another Sheet

  • Thread starter Thread starter franciz
  • Start date Start date
F

franciz

Hi

In col F of Sheet1 lists the code "Cash" or "Credit"
I want to move all the "Credit" to another sheet named "Credit"

How do I accomplish this with a macro

thanks,
 
If you use
Data>filter>autofilter>filter on col F for cash.
Voila. Now you may decide that you really don't need to copy to another
sheet when you can filter.
 
Record a macro while autofiltering for "Credit"

Copy the visible rows to the other sheet.

Delete the originals if required.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Auto Copy Data from one worksheet to another 1
Find matching values, copy/paste values as well as values in ColA 2
move data w/o blank data to another sheet 1
Move Flagged Row(s) to a Different Sheet 8
Add up cell from sheet 1 to show on sheet 2 5
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Macro to match 2 column values in different sheets 1
Invalid qualifier with dates 2

Back
Top