How do I paste data into filtered list in Excel?
 

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?

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

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

"Debra Dalgleish" wrote:

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

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

You comfortable with macros?

http://groups.google.co.uk/groups?th...apeXSPAM.c om

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

DanBomb wrote:

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

"Debra Dalgleish" wrote:

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



--

Dave Peterson