Search And Delete Routine Based On Conditions

Hi there!
I'm quite new to VBA programming and would greatly appreciate help as nothing I have found so far on the subject really fits.

Usually my data set consists of a max. of 12,000 rows. I need to delete the entire Row if either of the 2 following conditions are met:
1) In Column Y it says "Execution Only"
2) In Column Y it says "No Advice" AND in column F of that same row it says "Appropriateness profile required"
Other contents are possible but should not lead to any deletions. Using a simple IF... Then approach takes a horrendous amount of time (more tahn 20 mins.). There is however an approach using a select...case statement where the program jumps directly to the next row in which a deletion is to take place, but I wasn't able to figure it out.

Any help on this would be greatly appreciated!

Farout,
Since you have a large data, it would be easier to test the code if you could attach a sample book.

Hi Tigeravatar,

I'm overwhelmed! Seems to work like greased lightning... Many thanks.!!

Will do...I just need to insert this into the larger macro and see if it still works.

Hi Tigeravatar
Something still baffles me. Your program works fine individually, but as soon as it is inserted into the larger macro the part with the dual condition ("No Advice" + "Appropriateness profile required") doesn't work. If I cut these cells and paste them on a separate Excel Sheet it works again.
The master sheet hides certain columns that are not needed. Also an Auto-Filter is used. If I show these hidden columns again and deactivate the Auto Filter it works again. Any idea what could be going on here?
Greets,
FarOut

Hi Tigeravatar,

Works now and I'm thrilled. A big thank you for your speedy help . Have now marked the thread as "solved".

Best regards,
FarOut