paste filtered data in unfiltered list

J

jovobas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered Data 2
Copying Portions of Data 0
Cell data entering slow! 0
Filtered drop down list 2
Why does the skip blanks (paste special) function not work? 2
Pasting into a filtered sheet 3
paste special 3
MACRO HELP, PASTE CELL TO COLUMN 0

Top