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.