regarding filter

[Guest]

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?

 

[Tom Ogilvy]

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

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?

 

[Guest]

beatiful Tom thank you very much, though i was trying to do this
programmatically but a simple <> the rep name worked great.
Ben