First of all, I created a thread yesterday that User: Leith Ross [Thanks Leith for the help yesterday] was helping me with yesterday. This is a separate question and should be a simple solution.
I have the following code I'm using to cycle through items in a drop down list, then copy the sheet each time it's updated with a new item to a new workbook. The one thing missing I'd like is if I could have the sheets go in order in that new workbook. Currently - it's a list of 26 cities in alphabetical order - they populate into the new workbook in reverse order, since I'm using =before... I'm sure there is a simple solution i'm missing? I've included the workbook if that helps...
Please Login or Register to view this content.