Automatic sorting of sheets in an Excel project folder

[oynaz]

Hi guys

I have inherited a big excel sheet, which I need to keep updated. It is in the form of a single project folder with one sheet for each customer. The problem is, said sheet is not in alphabetical order, and there are hundreds of them. Needless to say, this does not improve my productivity.

Is there a way to make Excel sort the sheets in alphabetical order?

 

[Sam25]

I'm not very good with Excel so I Googled a bit and found this solution. I hope it works for you.

 

[oynaz]

Thanks for the help. I will give it a try.

 

[Sam25]

No problem! 🙂