| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delete Rows where cells does not meet criteria
My workbook has 14 columns and more than 1000 rows.
Column C header is Last Payment Date and Column F header is Next Payment Date. I need to DELETE all rows that has a different date other than 9/1/05 in Column C and 10/1/05 in Column F. Everyday, I temporarily insert a column in Column A, copy Column C, paste in Column A, sort and delete the rows (same procedure for Column F). Is there a worksheet function or macro that will automatically do this? Thanks for your help. |
|
#2
|
|||
|
|||
|
check out auto filter for the selections
"Danny" wrote: My workbook has 14 columns and more than 1000 rows. Column C header is Last Payment Date and Column F header is Next Payment Date. I need to DELETE all rows that has a different date other than 9/1/05 in Column C and 10/1/05 in Column F. Everyday, I temporarily insert a column in Column A, copy Column C, paste in Column A, sort and delete the rows (same procedure for Column F). Is there a worksheet function or macro that will automatically do this? Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
| In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Linear Mode
