Automating reading a cell's value & deleting its entire row if value true

Each morning I receive a 5000 row employee database download with approx. 20 columns of employee data. One of these columns is the Employee's Code - a letter followed by two numbers. Right now I'm manually sorting that Employee Code column A-Z and then highlighting and deleting all the rows of employees who have a D or R codes. There are 20 some different numbers in each code (D05, D22, R18, R20, etc.). Is it possible to automate this process? I'd like to set it up with a wildcard symbol or an * or something that would identify and completely delete every row containing a D or R (or whatever letter I choose) in the Employee Code column cells. Hopefully there is a fairly simple way to do this that I'm not seeing... I am using Excel 2007. Fairly good with macros, my VBA skills are at the dummy level - but I'm a fast learner and don't easily give up. Thank you in advance.

im a beginner but im doing a little searching. i think the correct trail for this problem is the ISLIKE function.

this may help

http://www.ozgrid.com/forum/showthread.php?t=17869

Your code worked great Seamus... Thank you.