make a macro to move specific rows to another sheet

B

braxton

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
 
G

Gord Dibben

braxton

Go to Data>Filter>Autofilter on "resolved" in the "status" column then copy
those rows to a new worksheet.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight rows if column A matches but B is different 0
Need Help with a VBA subroutine 0
How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet? 1
Finding Duplicate Rows & Highlighting them 6
How can I print rows that go outside of the page without shrinking the text? 0
Drop down list control value in vba 2
Too Few Rows to copy sheet to another book 2
Macro for moving rows 3

Top