Get Order Data

Setting up the function to get order data for next years

1.) Duplicate the former sheet and rename to "Data [year]". e.g. "Data 2023"

2.) On the new sheet, modify year on cell D1-01.

3.) On the new sheet, remove the previous order data from D2-02 up to 26th row.

4.) On google sheet menu, click "Extensions" -> "Apps Script" then update the year on line 15. Save by clicking the "Floppy disk" icon.