Automatically remove unwanted rows

**xlsior** · 12-13-2007, 11:25 AM

Hi all,

Im not strong in excel, that why Im here. So:
I work every day with big amount of item numbers and lists in excel and I need some macro or code to automatically remove rows, containing unwanted text.

Example:

MEMORY DIMM 512MB PC3200 DDR
MEMORY DIMM 512MB PC6400 DDRII
MEMORY DRIVE FLASH USB2 2GB
MEMORY MINI SD 2GB W/ADAPTER
MEMORY SECURE DIGITAL 2GB
MEMORY DIMM 1GB PC6400 DDRII
MEMORY DRIVE FLASH USB2 1GB
MEMORY DRIVE FLASH USB2 1GB

So I paste the text from my database, and want to automatically delete rows containing DIMM string. How can I do it?

p.s. is there also a way to leave only the rows I want?

**corinereyes** · 12-13-2007, 12:14 PM

Hi,

Put this code in a VB module, select for example column A (rows that contains the word "DIMM"), then go to Tools->Macro, then select macro named "deleteRows", click run.

Please Login or Register  to view this content.

**xlsior** · 12-14-2007, 08:04 AM

but this will delete only the whole words DIMM or also the words, containing DIMM? i have tried, and still all the DIMMS are in my sheet.

**royUK** · 12-14-2007, 08:58 AM

Try using the Forum search. My code here the can be changed to do what you want.

http://www.excelforum.com/showthread...ighlight=union

**xlsior** · 12-14-2007, 09:51 AM

gives me "Compile Error: Expected End Sub"

what that means?

**corinereyes** · 12-14-2007, 10:00 AM

Originally Posted by xlsior

but this will delete only the whole words DIMM or also the words, containing DIMM? i have tried, and still all the DIMMS are in my sheet.

select column A first then run the macro. the code deletes the row that contains the word "DIMM" on it. try the attached sheet.

Hope that helps.

**royUK** · 12-14-2007, 10:08 AM

Originally Posted by xlsior

gives me "Compile Error: Expected End Sub"

what that means?

You haven't copied the code correctly, you have missed the End Sub line

**corinereyes** · 12-14-2007, 10:08 AM

Originally Posted by xlsior

gives me "Compile Error: Expected End Sub"

what that means?

with RoyUk's code maybe you didnt able to copy the "End Sub" at the bottom of the code, try typing "End Sub" at the bottom of the code in the macro module.

**shyness_2205** · 01-04-2010, 12:45 AM

Hi!

Can anyone help me with the solution to this problem?
I want to auto delete the entire row under the column of time with a specific time of 12am to 7am of the next day. I want it to be auto updated from day to day. The only time I need to retain is from 8am until 11pm with its containing row. Appreciate your kind assistance.

12:00:00 AM
1:00:00 AM
2:00:00 AM
3:00:00 AM
4:00:00 AM
5:00:00 AM
6:00:00 AM
7:00:00 AM8:00:00 AM
9:00:00 AM
10:00:00 AM
11:00:00 AM
12:00:00 PM
1:00:00 PM
2:00:00 PM
3:00:00 PM
4:00:00 PM
5:00:00 PM
6:00:00 PM
7:00:00 PM
8:00:00 PM
9:00:00 PM
10:00:00 PM
11:00:00 PM
12:00:00 AM

**teylyn** · 01-04-2010, 01:03 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.