2021年1月1日星期五

Automate periodic copy of variable range to first blank row within another tab, within the same spreadsheet

I'm looking for a solution to periodically copy a range from one tab to another, within the same spreadsheet. Any help is appreciated!

The target range has fixed columns but the rows vary each day. The destination tab is a historical record of each day's entries, so same columns lots of rows. The target range is pasted in the first blank row on the destination tab.

Here's an example of what I'm trying to automate:

https://docs.google.com/spreadsheets/d/1o-BqJHgz1crI3w4GruFxfRs10PMZloMCiB0SGTVbTtw/edit?usp=sharing

https://stackoverflow.com/questions/65535437/automate-periodic-copy-of-variable-range-to-first-blank-row-within-another-tab January 02, 2021 at 10:05AM

没有评论:

发表评论