I am looking to post a range from one spreadsheet into another which has hidden rows due to filtering and i would like to ignore these rows.
for example, this would be the range.
A1122334455667788991010
And i would like it to paste here
A112288991010
but as you can see, it is filling in the...