| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Macro for sorting different rows | Excel Worksheet Functions | |||
Linear Mode
