copy and paste filtered cells
 

I want to copy cells that are filtered to another worksheet that has filtered
cells. When I paste the filtered cells into the destination worksheet it
doesn't copy into the filtered cells rather it copies the data ignoring the
filter. For example, if I copy rows 1,4,7 and I want it to copy those cells
into another worksheet that is also filtered in rows 9,14,18, the result
from 1,4,7 should be shown in 9,14,18. My result shows 9,10,11 (it's
ignoring the filter).

copy and paste filtered cells
 

Pasting into a range that contains hidden rows won't stop excel from pasting
into a contiguous range--whether those rows are visible or hidden. That's the
way excel works.

Maybe you can sort the "receiving" range so that the pasted cells are all
contiguous. Then resort them into the order when you're done.

Rich wrote:

I want to copy cells that are filtered to another worksheet that has filtered
cells. When I paste the filtered cells into the destination worksheet it
doesn't copy into the filtered cells rather it copies the data ignoring the
filter. For example, if I copy rows 1,4,7 and I want it to copy those cells
into another worksheet that is also filtered in rows 9,14,18, the result
from 1,4,7 should be shown in 9,14,18. My result shows 9,10,11 (it's
ignoring the filter).

--

Dave Peterson