Hi,
I'm trying to fully automate a marketing report for my company on Google Sheets.
We have a list of metrics that we track on a monthly basis.
Each month, new data comes in and I need to manually :
- Create a new column
- Paste the values from the column that contains all the formulas to the newly created column.
Is there any way to automate these two tasks? I've never used macros before but I'm guessing I will need it.
I attached a sample of my data so you can understand better what I'm trying to do.
Any help would be appreciated !
Bookmarks