paste a copied range of cells into a filtered range

[paulgunther]

I have adjacent cells with data on one worksheet that needs to be pasted into another sheet based on criteria. After filtering the target sheet to display only data meeting the criteria, I'm left with cells that are not adjacent. i.e., rows 1,7 48 56, etc. And on the other sheet I need to copy a column with rows 5,6,7,8, etc. and paste them into the other sheet.

 

[Artik]

Please explain again what you need.
Do you want to copy rows 1, 7, 48, 56 from Sheet1 and paste them into 5, 6, 7, 8 in Sheet2? Or conversely, do you want to copy and paste rows 5, 6, 7, 8 in Sheet2 into rows 1, 7, 48, 56 in Sheet1?

Artik

 

[paulgunther]

Please explain again what you need.
Do you want to copy rows 1, 7, 48, 56 from Sheet1 and paste them into 5, 6, 7, 8 in Sheet2? Or conversely, do you want to copy and paste rows 5, 6, 7, 8 in Sheet2 into rows 1, 7, 48, 56 in Sheet1?

Artik

Conversely. I copy from adjacent cells and paste into filtered cells which appear to be adjacent, but actually have hidden cells between.

I hope that makes sense.

Thanks Artik!!

 

[Akuini]

@paulgunther
See if this article helps:
Excel VBA: easy way to paste to visible cells