Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Copying and Pasting While Filtered

  1. #1
    New Member
    Join Date
    Mar 2006
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copying and Pasting While Filtered

    Hi,

    I use filters a lot at my work. One thing I've noticed is that if I have something filtered and want to copy and paste only what I see from one column to another column right next to it, it will copy what is filtered, but then paste into the unfiltered portion.

    Is there some way to copy only what I see when it's filtered, THEN paste only onto the adjancent cells which is also filtered?

    For example let's say i have each of the number below in a cell (Fig 1). And then I hide rows 2 -3, so only 1 and 4 is showingI only see 1 & 4 in column A. I want to copy and paste 1 and 4 to the next column over one row so it looks like Fig. 2 when unhidden. Not like Fig. 3.

    Fig. 1

    1
    2
    3
    4

    Fig. 2

    1 1
    2
    3
    4 4

    Fig. 3
    1 1
    2 4
    3
    4

  2. #2
    MrExcel MVP Oaktree's Avatar
    Join Date
    Jun 2002
    Location
    Chicago, IL
    Posts
    7,913
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copying and Pasting While Filtered

    1) Filter column A
    2) Select B2:B100 (through the end of your data) and press alt + ; (to select visible cells only)
    3) type =A2 and press CTRL+ENTER
    4) remove your filter
    5) If desired, copy & paste values from column B
    "The greatest challenge to any thinker is stating the problem in a way that will allow a solution." Bertrand Russell

  3. #3
    New Member
    Join Date
    Mar 2006
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copying and Pasting While Filtered

    Thanks for the reply. I already use that method. It definitely works, but can be a bit cumbersome. Anyone else have a quicker method?

  4. #4
    Board Regular
    Join Date
    Jun 2008
    Location
    North Carolina
    Posts
    2,465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copying and Pasting While Filtered

    refering to post 3
    Nope

    actually people have macros to do this. the macros can be quite cumbersome depending on the details of what is wanted.
    May I deal with Honor
    May I act with Courage
    May I strive for Humility
    "Straight" By **** Francis

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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