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?