Microsoft Excel - Sort Sheets Alphabetically

Learn how to easily add a small amount of VBA code to your Excel world to give you the ability to sort your sheet tabs in either ascending or descending order.
Importable VBA code:
www.bcti.com//...
Quick Access Toolbar - Ultimate Customization Guide:
• Microsoft Office - Qui...
VBA Code for Copy/Pasters:
=======================
(I found out too late that certain symbols in the VBA code are not allowed in a TH-cam description field. You can still download the file, open it in Notepad, then copy/paste it from there.)

[@renshaw6477]

Thanks for the vid mate. Very clear and easy to follow. Saved me hours!!!

[@bcti-bcti]

You are very welcome. Glad it helped.

[@kebincui]

You are always great in producing so excellent tutorials 👍. Thank you very much.

[@bcti-bcti]

Thanks so much for taking the time to watch and comment nicely!

[@RadAlzyoud]

Very helpful.
I always wondered why.
Thank you for the video/code and totally agree with you regarding this.

[@paulinamartinez2412]

this is amazing, thank you!!

[@bcti-bcti]

So glad you found it helpful. Perhaps one day Microsoft will as well.

[@willbedeadsoon]

Great lesson as always

[@hankgrimes1806]

Good functionality to have in my arsenal. Would you please explain the difference between saving to your Personal Macro Workbook and saving as a Macro Enabled workbook?

[@bcti-bcti]

Check out this video I made on the Personal Macro Workbook.
th-cam.com/video/IGj-Ke8XWLo/w-d-xo.html
If you are still unclear after watching, please let me know and I'll answer your specific questions.
Cheers

[@ish011]

You're a great help, Thank you!

[@bcti-bcti]

You are most welcome.

[@ExcelUnlocked]

Amazing

[@bcti-bcti]

Thanks for saying so.

[@seanmurphy4077]

I had an issue with having to sort by color THEN alphabetical…that was not a fun code to figure out!

[@bcti-bcti]

I thought about showing the "sort by color" version, but I didn't want to make the video any more complicated than it needed to be. I feel your pain. I don't think I've ever done it as a hierarchical sort. That sounds challenging. Thanks for watching.

[@et.sachin]

Is it possible to replicate the QUERY function from Google Sheets on Excel?

[@bcti-bcti]

There is no direct analog in Excel's function library to Google Sheets' QUERY function. You would likely need to use a combination of Excel functions to achieve the same goal. Functions like FILTER, CHOOSECOLS/CHOOSEROWS, UNIQUE, SORT/SORTBY, TAKE/DROP, etc.

[@et.sachin]

@@bcti-bcti can you please try to do a video on that

[@bcti-bcti]

@@et.sachin This would be a MONUMENTAL video as Excel does not have a single function that executes all of what Google Sheets' QUERY() function performs. If it helps, below is a list of Sheets' QUERY() arguments and what would be analogous using Excel functions:
Sheets ------> Excel
------------------------------
Select ------> ChooseCols
Where ------> Filter
Group By ------> GroupBy
Pivot ------> PivotBy
Order By ------> Sort
Limit ------> Take
Offset ------> Offset
Label ------> VStack
Format ------> Text