Delete Rows based on Multiple Name Criteria

**Graham Taylor** · 06-01-2012, 01:17 PM

Greetings,

I have a pretty simple one that I can't get my arms around. Need a short VB script to run a macro that will delete entire rows based upon multiple criteria (Names with Spaces)

In non tech terms my example is.... If Column B = John Smith or John Doe, or Jane Smith, or Carlos Hernandez then delete the entire row. (There are 8 names total)

I have hunted around and not found anything yet that will properly do this.

Any help would be greatly appreciated!

**jeffreybrown** · 06-01-2012, 01:40 PM

Hi Graham,

See if you can modify this with your criteria and give it a whirl. Don't forget about the correct sheet name.

Please test on a sample first...

Please Login or Register  to view this content.

**Graham Taylor** · 06-01-2012, 01:44 PM

Worked PERFECTLY! Thanks

**jeffreybrown** · 06-01-2012, 01:46 PM

You're welcome. Glad it worked out for you and thanks for the feedback

If satisfied with the solution(s) provided, please don't forget to mark the thread as solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

**MXu** · 10-14-2012, 08:07 AM

In the above example, the use of "AAAA", "BBBB", requires the criteria to be inputted in the VBA code. Is there a way to reference criteria in a column listed in a separate sheet of the same file?

I have a database of about 3500 names listed on one sheet in column B. Each name has a row's worth of data assosciated with it; some of the names are repeated, but the associated data is different. This sheet is called "Crew Qual." I want to be able to input a separate list of names on a separate sheet in the same file: "Qual Math", range O6:O19, and have excel reference the inputted names, and delete the associated rows in the sheet "Crew Qual."

I looked around in other forums, and have not found a good solution, can anyone help?

**jeffreybrown** · 10-14-2012, 09:06 AM

@MXu,

Welcome to the Forum, unfortunately:

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. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.