Find Value and Move Rows to another Sheet
 

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,

Find Value and Move Rows to another Sheet
 

If you use
Datafilterautofilterfilter 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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"franciz" wrote in message
...
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,

Find Value and Move Rows to another Sheet
 

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

On Sun, 14 Sep 2008 11:30:00 -0700, franciz
wrote:

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,