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