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
Bookmarks