automatically filter out blanks in multiple columns

[gmr7]

I have a spreadsheet with numerous columns (different job #'s), and under
uner job is a list of supplies needed. Is there any way to automatically
filter out blank cells of all the columns at the same time?

 

[Debra Dalgleish]

You could add a column to the table, and use it to count the number of
jobs that have an entry in that row.

For example, in cell M2, enter: =IF(COUNTA(B2:L2),"Yes","No")
Copy the formula down to the last row of data.
Then, filter column M for Yes or No.

 

[gmr7]

http://www.contextures.com/AdvFilterRepFiltered.xls

This macro is what I am looking for. However my sheet is based on 6-digit
job numbers (in lieu of "rep"). The macro works for the 1st run, but when I
change a job number or add a new job number, it is giving me an error

run-time error '9';
Subscript out of range

Any advice??