+ Reply to Thread
Results 1 to 4 of 4

How do I paste data into filtered list in Excel?

Hybrid View

  1. #1
    DanBomb
    Guest

    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?

  2. #2
    Debra Dalgleish
    Guest

    Re: How do I paste data into filtered list in Excel?

    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


  3. #3
    DanBomb
    Guest

    Re: How do I paste data into filtered list in Excel?

    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
    >
    >


  4. #4
    Dave Peterson
    Guest

    Re: How do I paste data into filtered list in Excel?

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1