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...scapeXSPAM.com

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