How do I paste data into filtered list in Excel?

[DanBomb]

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]

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]

Thanks Debra. There must be a more direct solution (anybody knows?) but it is
definitely a good work-around. Thanks

 

[Dave Peterson]

I don't think that there's anything more straight forward for doing it manually.

You comfortable with macros?

http://groups.google.co.uk/[email protected]

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm