Pasting into a filtered region

[Bart]

How can I copy and paste data into a filtered region.
Example : Worksheet 1 ( I want to copy row 1-20 ).
Worksheet 2 ( I want to paste these rows into a filtered
region on the second worksheet).

Thanks.

 

[Debra Dalgleish]

When you paste, the data is pasted in to a contiguous range, even if the
sheet is filtered. Perhaps you could use a new column to mark the
filtered rows, unfilter, sort on the new column, and paste into the
marked rows.