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.

DanBomb wrote:
I'm trying to copy data from an unfiltered list and paste it into a filtered
list. I want the data to be pasted into the filtered rows only but they are
pasted into the hidden rows as well. Is there a function I can use to get the
data pasted into the filtered rows only?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html