Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Row when date in activecell doesn't meet the requierments
I have a worksheet containing startdate in Column G and enddate in Column H
per user. I want VBA to test if a user doesn't meet the specifics (from an inputbox), and then delete the entire row. So basically if user's contracted has to be activated on or after 1-1-2008 and expired on or before 31-12-2009, all users that do not meet those specifics get deleted. The date (i.e. criteria) should be entered through an inputbox. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete data in cells that don't meet criteria | New Users to Excel | |||
Delete rows that do not meet specific criteria | Excel Programming | |||
Delete rows that don't meet specific criterion | New Users to Excel | |||
Delete Rows where cells does not meet criteria | Excel Worksheet Functions | |||
how do i delete rows when cells meet certain criteria? | Excel Programming |