I have a google spreadsheet that includes a couple of sheets that are dynamically maintained from a variety of sources. Call them Dynamic_data1 and Dynamic_data2.
For each of these dynamic sheets there is a companion static sheet. Let's call them Static_data1 and Static_data2.
I have a periodic need do the following for these two pairs of sheets, which I have been doing manually:
- Delete the entire contents of Static_data1
- Copy the entire contents of Dynamic_data1
- "paste special/paste values only" the values from Dynamic_data1 into Static_data1
Then repeat the process for Dynamic_data2/Static_data2
It's always the whole sheet, regardless of the number of rows or columns present.
Doing this manually works fine, but I find I have the need to automate it. I've done a little scripting, not much, so I am no expert.
I can't help but think this should be a simple job for a script. However, my inept googling has not located something I can adapt. I'd be grateful for advice.