Forum Discussion
Resort Excel sheets, change the order
I'm needing to change the order of my excel sheets, cannot find a tool in my MS 365.
Thanks for the reply, I would of course welcome seeing any sorting macro for the entire workbook of sheets. I have about 25 sheets and will be generating more. I have a program that outputs tables to each sheet. Each sheet is named alphabetically, like an index.
I was going to write something quick but did a search first and found plenty that already have examples and much better instructions/documentation than I would have done. Here are just a few:
from MS:
https://docs.microsoft.com/en-us/office/vba/excel/concepts/workbooks-and-worksheets/sort-worksheets-alphanumerically-by-name
good description and instructions:
https://trumpexcel.com/sort-worksheets/
simply the macro:
https://www.automateexcel.com/vba/sort-sheets-alphabetically/
from MS:
https://docs.microsoft.com/en-us/office/vba/excel/concepts/workbooks-and-worksheets/sort-worksheets-alphanumerically-by-name
good description and instructions:
https://trumpexcel.com/sort-worksheets/
simply the macro:
https://www.automateexcel.com/vba/sort-sheets-alphabetically/