| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Row to Another Sheet Based on Cell Value
Hello,
All of the cells in SheetA, column B, have values of either "X," "Y," or "Z". I need a macro that will look through each row of SheetA and copy the rows that have "X" in column B to SheetX, "Y" to SheetY, and "Z" to SheetZ. If column B is blank or has any value other than "X," "Y," or "Z", nothing should be copied. Any ideas where to begin? Thanks... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
| VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column | Excel Programming | |||
| Copy rows from one sheet to another based on a cell value | Excel Worksheet Functions | |||
| Copy rows from one sheet to another based on a cell value | New Users to Excel | |||
Threaded Mode
