Previous Topic Next Topic

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
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.

1 response

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 13, 2009 at 04:11 AM
Hi
Just Filter and delete

Similar discussions

How to modify the macro code for new structure of table
jpppol -
TrowaD -

9 responses
How to create a macro to copy and paste
johncarr1973 -
ac3mark -

3 responses
Convert data with rows into columns
pooja.bs -
TrowaD -

2 responses
Automatically update a cell with last modified date and time
NazCarr -
NazCarr -

2 responses