paste filtered data in unfiltered list
 

When I copy a filtered column from one worksheet and paste it into
another worksheet with unfiltered data, excel behaves very strangely.
A normal paste just fills the first couple of rows, a pastespecial
with skip blanks just fills the first couple of rows. At some point
Excel recognizes that it must skip the blanks and then normal paste
and paste special with skipblanks puts the data in the right row. Once
this happens it always skips the blanks.
I want it to skip the blanks from the first time around. Any ideas
anyone ?
Thanks