| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to move rows from one sheet to another sheet (macro) | Excel Discussion (Misc queries) | |||
| Find account, move them to different sheet MACRO | Excel Discussion (Misc queries) | |||
| find value in column and move row to 5 rows after the last one.......... | Excel Programming | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| How to move rows in a Sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
