I need to put data into a spreadsheet built and maintained by someone else
for a variety of uses. The rows I care about are not consecutive, but appear
consecutive when the file is filtered. I compile my data in another
spreadsheet and want to copy-and-paste into the first spreadsheet. To avoid
having to tediously copy each row individually, I would like to be able to
copy the entire data set from my own spreadsheet and then paste it into the
first spreadsheet in a single operation. Is there a way to paste so that the
values go only into the visible cells?