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