| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows in excel by service date
I have an excel sheet that contains about 300 rows of data. One
column, P, has the hire date. What I'm looking to do via vba is to delete all rows where the hire date is not 3 months prior next month. In other words, next month is June, so I want only those rows where the hire date is the month of March (3 months prior to June)...I normally use the filter commands which works OK, but I thought since this is a monthly report I can speed things up and run it via VBA. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete rows based on date | Excel Discussion (Misc queries) | |||
| Delete rows with date more than 48 hours with a condition.. | Excel Worksheet Functions | |||
| service date | Excel Discussion (Misc queries) | |||
| How do you format an auto update to delete rows with expired date | Excel Worksheet Functions | |||
| Excel VBA - Delete rows within a date range | Excel Programming | |||
Threaded Mode
