1 min readfrom 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".

submitted by /u/magickrhythm
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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