Copy Row to Another Sheet Based on Cell Value

  • Thread starter Thread starter gth0824
  • Start date Start date
G

gth0824

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...
 
How about this idea
data>filter>autofilter>filter on x>copy to sheetx >filter on y>copy to sheet
y,etc >filter to remove the filter arrows
record a macro and then clean it up.
 
Back
Top