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).