Query in Macro
Closed
cool
-
Sep 10, 2009 at 02:10 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 13, 2009 at 04:11 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 13, 2009 at 04:11 AM
Hello,
i have an excel file. contains 2000 rows and 6 columns. if Column "A" contains "1" and Column "B" contains "sweet", the entire row has to delete.
For example, almost 100 rows may be like that. But i wanted to delete all 100 rows.
Please any help on this.
i have an excel file. contains 2000 rows and 6 columns. if Column "A" contains "1" and Column "B" contains "sweet", the entire row has to delete.
For example, almost 100 rows may be like that. But i wanted to delete all 100 rows.
Please any help on this.
Related:
- Query in Macro
- Spell number in excel without macro - Guide
- Macros in excel download free - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- How to avoid duplicate records in sql select query - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Sep 13, 2009 at 04:11 AM
Sep 13, 2009 at 04:11 AM
Hi
Just Filter and delete
Just Filter and delete