Do i use a filter or a macro?
 

I have a list of 7400 ppl where some of them have similar member numbers.

col A has "Not Found" for members who are to be moved to another worksheet.
other members who need to be moved have member numbers (column B) similar
to the "not found" members yet do not have "not found" in col A

Is there a way i can filter "not found" in column A and for all visible
member numbers. see also all filtered-out similar member numbers.

there after i need to move out these rows to a different worksheet but if am
able to filter it th way i want that would be easy. othewise i need a macro
that sees "not found" in column A, reads the member number from column B and
looks for all similar numbers in column B and moves all data that fits these
criteria to sheet1 .

thanks

Do i use a filter or a macro?
 

Take a look at Data Filter Autofilter......then make selections from the
arrows at the top of your interested columns.........to revert all back to
normal, just do data Filter Autofilter again....it's a toggle.......

hth
Vaya con Dios,
Chuck, CABGx3


"anthony" wrote in message
...
I have a list of 7400 ppl where some of them have similar member numbers.

col A has "Not Found" for members who are to be moved to another
worksheet.
other members who need to be moved have member numbers (column B) similar
to the "not found" members yet do not have "not found" in col A

Is there a way i can filter "not found" in column A and for all visible
member numbers. see also all filtered-out similar member numbers.

there after i need to move out these rows to a different worksheet but if
am
able to filter it th way i want that would be easy. othewise i need a
macro
that sees "not found" in column A, reads the member number from column B
and
looks for all similar numbers in column B and moves all data that fits
these
criteria to sheet1 .

thanks

Do i use a filter or a macro?
 

looks like u didnt understand my qtion.

A B C D
not found james jones 0112
john doe 0112
JEAB DOE 0112

I need a macro that sees "not found" in the first column, reads the member
number from column d, and cuts from that worksheet all rows having that
member number and move them to another worksheet.
i guess only macros can work for this.
thanks in advance