Pasting into a filtered region

  • Thread starter Thread starter Bart
  • Start date Start date
B

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.
 
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.
 
Back
Top