I am looking to write a script that takes the entire columns of data in columns B and C, and archives/inserts it into D&E on a weekly basis, so that eventually the older data is on the far right with weekly newer data being added to columns D/E.
Columns B/C get updated every Monday automatically.
I’d recommend checking out Google Sheets’ built in macro features where you can record an action and set a timed trigger so that it will run your recorded action (the macro) every week.
