Forum Discussion
How to Automate a Rostering System
Hello, and thank you to all who respond constructively. I am currently attempting at automating a rostering system for 50 employees. They are unionized, and they have the ability to bid on differe...
About the automation, as mentioned by NikolinoDE , you may use VBA or Office Scripts, and both tools are connected to another Microsoft solution, which is the Power Automate, which contains several connectors with other Microsoft products and third part ones. As in Excel, the Power Automate community is very active and will be able to help you with the automation share of your solution.
Here are some links about it:
Blog post that compares VBA with Office Scripts: http://digitalmill.net/2023/06/10/office-scripts-the-new-vba/
Power Automate documentation: https://learn.microsoft.com/en-us/power-automate/
Access to Power Automate Community: https://powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums