Paste into filter column

[MiniFav]

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.

Book1
	A
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
Sheet1

And i would like it to paste here

Book1
	A
1	1
2	2
8	8
9	9
10	10
Sheet1

but as you can see, it is filling in the hidden rows rather than skipping rows 3-7 and using 8-15 instead.

This is probably something simple which my online search isnt picking up, i can only really see ways to copy data and ignore hidden rows.

Thanks in advance!

 

[Akuini]

See if this helps:

Copy data from a filtered list to another filtered list

Dear Users, I'm trying to copy a range of filtered cells to a destination range of other similar filtered cells. Here is a little example I'm trying to use with some VBA code I found below. Refering to...

www.mrexcel.com