Hi, I am going to be working on a spreadsheet which will have a tab for every member of staff in my faculty (could be over 100 tabs).
I need to write a Macro that will, when run, sort the tabs into alphabetical order (they will be named as 'Last name, First name'). Is this possible? Also, it would be great if, when we re-run the macro as the semester progresses and more people are added, we can re-run the macro and it will re-read all the tabs and include the new tabs in the re-ordering. Thanks, Amanda --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
