Search : in
By :

Query in Macro

Last answer on Sep 13, 2009 9:11:59 am BST cool, on Sep 10, 2009 7:10:39 am BST 
 Report this message to moderators

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.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Query in Macro » in :
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
[Oracle]Query Optimization Show[Oracle]Query Optimization Oracle comes with an optimizer to optimize the plan executing a query. Sometimes the data features in the database are rapidly changing, so that the optimizer (the stats) is updated. In this case, the hints may...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Download EMS SQL Query for PostgreSQL ShowTo store and handle your information, the use of a database such as PostegreSQL simplifies your task. By means of different queries, you can easily extract information which you need at any time. EMS SQL Query for PostgreSQL is a program to...

1

 Excelguru, on Sep 13, 2009 9:11:59 am BST
  • +1

Hi
Just Filter and delete A wise man once said, 'I complained that I had no shoes unti­l I met a man who had no feet.'
I am interested in financial Modelling and custom excel deve­lopment with excel macros.

Reply to Excelguru