Couple Changes to a copying and sorting macro

Hi,
I have a macro here that takes information, sorts it by band names, and copies that sorted information into a new sheet. The first time it runs, there are no problems. But since i am using it to update information that continues to get input daily, each time I click the button to update, i need it to completely erase the original information, rather than copy over the top of it, because the more information i update, the more old information it is writing over. I've Attached the file, the button for the macro (SortByEntertainer) is on the "Band Performances" sheet, and it is drawing information from the "All Entertainment" sheet. Thanks for the help.

E

Hi

Try this

Please Login or Register  to view this content.

rylo

Works well, I appreciate that. Anyone happen to know how i can add that button to the "All Entertainment" Sheet, but still have the macro take me to the "Band Performances" sheet as a part of the process?