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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Row to Another Sheet Based on Cell Value
How about this idea
datafilterautofilterfilter on xcopy to sheetx filter on ycopy to sheet y,etc filter to remove the filter arrows record a macro and then clean it up. -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... 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... |
Reply |
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 |