•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to sort tabs using an Office Script instead of VBA
Is there an Office Script that will sort all of the tabs in a workbook alphabetically but ignore certain tabs?
I have a VBA script that will do the job, but I don't want to use VBA anymore.
Example I have a workbook with employee last names, one tab for each employee. There are about 60 tabs. I also have a summary tab at the start of the workbook. When I add a new employee tab, I have to move it to the right place alphabetically. It would be nice to have a Office Script Automated Button that will just resort all the tabs, but leave the Summary tab as the first tab, not sort it to the "S".
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#automated anomaly detection
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#Office Script
#tabs
#VBA
#sort
#workbook
#summary tab
#alphabetically
#employee
#Automated Button
#ignore
#resort
#not sort