Delete rows with missing data

Help!

i maintain a training matrix in Excel. Yes, I know it should be in Access but my company has dictated that this is how it should be created. It is large with 250 different job titles and 300 or more training topics. I track the requirements for each job title by entering an x in the appropriate cell. I need to be able to create schedules for a specific job title or titles as some people perform many different roles. for example, in the sample spreadsheat I need to have a macro that will eliminate rows 9 and 12 because they do not pertain to the job roles that are indicated on the form. I only know enough about VB to ge tin trouble i'm afraid.

Thanks in advance.

For what its worth, I have a bit of code I've been using to delete rows if it contains a certain letter. I'm not sure if you could insert "cells.blank" or something similar in place of the letter "O". See below in blue... here is my code:

    Dim c As range, LR As Long, a As Long
        For Each c In range("D2", range("D" & Rows.Count).End(xlUp))
          If UCase(c.Value) = "C" Then
            range(Cells(c.Row, 1), Cells(c.Row, 39)).Font.ColorIndex = 3
            range("K" & c.Row) = range("K" & c.Row) * -1
         
          End If
        Next c
        LR = Cells(Rows.Count, "D").End(xlUp).Row
        For a = LR To 2 Step -1
          If UCase(Cells(a, "D").Value) = "O" Then
            Rows(a).EntireRow.Delete
          End If
        Next a

Thank you for your help. the filter works just fine. I haven't had a chance to try the code yet. You guys are great.