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,
|