Excel - Sort Sheets Alphabetically
Вставка
- Опубліковано 26 сер 2024
- 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 UA-cam description field. You can still download the file, open it in Notepad, then copy/paste it from there.) - Наука та технологія
You are always great in producing so excellent tutorials 👍. Thank you very much.
Thanks so much for taking the time to watch and comment nicely!
You're a great help, Thank you!
You are most welcome.
Very helpful.
I always wondered why.
Thank you for the video/code and totally agree with you regarding this.
Great lesson as always
Amazing
Thanks for saying so.
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?
Check out this video I made on the Personal Macro Workbook.
ua-cam.com/video/IGj-Ke8XWLo/v-deo.html
If you are still unclear after watching, please let me know and I'll answer your specific questions.
Cheers
Is it possible to replicate the QUERY function from Google Sheets on Excel?
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.
@@bcti-bcti can you please try to do a video on that
@@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
I had an issue with having to sort by color THEN alphabetical…that was not a fun code to figure out!
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.