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