I have obtained a macro (AdvFilterRepFitered) that can create sheets with
records for each rep in filtered list (if a sheet already exists for a rep,
it will be cleared, and the data will be extracted to that sheet). It will
create sheets with rep's name.

How could modify it so the names for the created sheets will be C1, C2, C3,
C4 (not rep's name)...(depending on how many reps we have)

Any help will be appreciated.
--
Aline