To regulate when your macros run, it is possible to assign them to specific functions within Excel, like opening a workbook, changing a sheet, or clicking a button. That is done with the VBA editor, where you can produce party-handler methods that set off your macros. This may be useful https://www.customguide.com/google-docs/how-to-make-a-table-in-google-docs