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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:7c7dec74-6093-42bd-a046-(E-Mail Removed)...
> 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...