+ Reply to Thread
Results 1 to 4 of 4

Paste range of values into filtered sheet

  1. #1
    Registered User
    Join Date
    06-29-2005
    Posts
    4

    Paste range of values into filtered sheet

    Hi,

    I have a worksheet unfiltered that have a range of values that I like to copy and paste it in another worksheet that is filtered. How can I do that? I have try to select the visible cells in the filtered sheet but it only works for single cell.

    Please help!!!

  2. #2
    Dave Peterson
    Guest

    Re: Paste range of values into filtered sheet

    It actually pastes into the rows that are hidden, too. You may want to go back
    and see if you've harmed your original data.

    I like to sort my "filtered" data so that when I paste, I can paste into a nice
    contiguous range.

    I'd show all the data, too--just to make sure I don't overwrite something I
    want.

    Then if I have to, I'll re-sort the data.

    ken2005 wrote:
    >
    > Hi,
    >
    > I have a worksheet unfiltered that have a range of values that I like
    > to copy and paste it in another worksheet that is filtered. How can I
    > do that? I have try to select the visible cells in the filtered sheet
    > but it only works for single cell.
    >
    > Please help!!!
    >
    > --
    > ken2005
    > ------------------------------------------------------------------------
    > ken2005's Profile: http://www.excelforum.com/member.php...o&userid=24734
    > View this thread: http://www.excelforum.com/showthread...hreadid=472010


    --

    Dave Peterson

  3. #3
    Registered User
    Join Date
    06-29-2005
    Posts
    4
    Hi Dave...well looks like sorting the data on the sheet first before pasting the range of data onto it seems to be a more practical way of going about. Just wondering if there is a faster way, any idea?

  4. #4
    Dave Peterson
    Guest

    Re: Paste range of values into filtered sheet

    I think that is the fast way.

    ken2005 wrote:
    >
    > Hi Dave...well looks like sorting the data on the sheet first before
    > pasting the range of data onto it seems to be a more practical way of
    > going about. Just wondering if there is a faster way, any idea?
    >
    > --
    > ken2005
    > ------------------------------------------------------------------------
    > ken2005's Profile: http://www.excelforum.com/member.php...o&userid=24734
    > View this thread: http://www.excelforum.com/showthread...hreadid=472010


    --

    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