This hidden Excel Automation feature is way more useful than it gets credit for
https://www.makeuseof.com/built-in-excel-automation-feature/
- Excel’s Office scripts
Automating repetitive work inside Excel - The Automate a task button
Let Excel run scripts for you
Office Scripts in Excel – Office Scripts | Microsoft Learn
https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel