make a macro to move specific rows to another sheet
 

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

braxton

Go to DataFilterAutofilter on "resolved" in the "status" column then copy
those rows to a new worksheet.


Gord Dibben Excel MVP

On Mon, 21 Feb 2005 10:09:13 -0800, "braxton"
wrote:

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