i have a spreadsheet called "complaints" and one of the column headings is
"status". the response is pending or resolved. now this is what i would like
to do. if the answer is "resolved" i want to move the whole row to a
different sheet, so the pending complaints will be more managable.

i appreciate any help i can get

braxton