| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Records according to One Criteria in one Field
Hi
Recording a Macro while filtering according to a criteria then deleting those records remaining will not work as the reference of the records deleted in the macro recorded could be different the next time round. Can anyone help me with the VB command that would delete all records that are equal to a criteria where the field name , in my case "FinancialCategory" , is equal to 50. Many Thanks Roger Ramseier |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Records according to One Criteria in one Field
See this page for a possible solution
http://www.rondebruin.nl/delete.htm Post back if you need more help -- Regards Ron de Bruin http://www.rondebruin.nl "Roger The Rabbit" wrote in message ups.com... Hi Recording a Macro while filtering according to a criteria then deleting those records remaining will not work as the reference of the records deleted in the macro recorded could be different the next time round. Can anyone help me with the VB command that would delete all records that are equal to a criteria where the field name , in my case "FinancialCategory" , is equal to 50. Many Thanks Roger Ramseier |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete records when certain records have duplicate column data | New Users to Excel | |||
| filtering out records from one worksheet by comparing a field in it with a field in another worksheet | New Users to Excel | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| How do I display records using a key field in Excel? | Excel Worksheet Functions | |||
| Unique Records by Field | Excel Programming | |||
Linear Mode
