Script to archive columns in google sheets


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.

Any help would be appreciated!

Welcome, @bees22 :wave:

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.

This blog post is a little dated, but the same basic steps apply. How to Make Macros in Google Sheets