instead of selecting the reps name from the drop down, select custom from
the dropdown and then select does not equal and select the reps name.

Now delete the visible rows.

--
Regards,
Tom Ogilvy

"ben" wrote in message
...
I have a large list of customer addresses including their rep codes, now i
can filter the list using autofilter to pull up a list of all the
customers
for one rep, but what i want to do from here is delete all the "hidden"
rows. In other words, have a completely new file with only the customers
from
one Rep, which is the filtering criteria, now i can loop through a macro
to
delete each hidden row individually, but this takes forever. any
suggestions?