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