Delete rows with missing data

[dmars]

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.

[JBeaucaire]

Non-macro solution:
1) J3 = "Key"
2) J4 =COUNTA(E4:I4)
3) Copy cell J4 down the whole data set
4) Click Data > Filter > Autofilter to turn on the AutoFilter for this data
5) Click J3 drop down and select Custom
6) Is greater than 0

Now all the rows that don't match are hidden. No VBA needed.

[curbster]

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:

Please Login or Register  to view this content.

[dmars]

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.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)