automatically filter out blanks in multiple columns
 

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?

--
gmr7

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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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??

--
gmr7


"Debra Dalgleish" wrote:

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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html