Copy Row to Another Sheet Based on Cell Value

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...
 
D

Don Guillett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to summarize same values 1
macro to copy columns from one sheet to another sheet 4
Create if partial match then copy and paste data from one cell to another 1
Comparing a cell value with a range in a table and displaying a response 0
Get/Find criteria and copy sum 2
X,Y,Z values to be extracted and posted respectively in excel 5
Code to copy cell values from one sheet to another 1
writing a value to a particular cell from function 3

Top