+ Reply to Thread
Results 1 to 4 of 4

Copy and paste data with filtered cells

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    65

    Copy and paste data with filtered cells

    I am trying to copy and paste values from one column to another on the same sheet

    E.g Column A

    A1-Red
    A2-Blue
    A3-Green
    A4-Red

    If i filter to red and copy cells A1 and A4 and paste into column B, instead of pasting it into cells B1 and B4 it pastes it into B1 and B2...

    How do i get it to paste on the same row?

    My sheet im working with has thousands of rows, some need to be pasted, others need to be left as they are

    Please help

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Copy and paste data with filtered cells

    Hi, rikkyshh,

    working with Filters for me means to have Row 1 as Header, not as Data.

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste data with filtered cells

    One way around is this.

    Choose a cell(let's say D1) and type the word "red" there(or use a validation list to choose it.

    Then in B1 and copy down, use this.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Copy and paste data with filtered cells

    hi rikkyshh. yet another way is if they are beside each other
    1. select A1:B4. or in your case of thousand rows, select A1. CTRL + SHIFT + DOWN. SHIFT + RIGHT

    2. press ALT + ; to select visible cells. or CTRL + G -> Special -> Visible Cells Only -> OK

    3. press CTRL + R to fill right

    if they are not beside each other, change the steps a little

    1. select the column you want to paste to only. say C1. then CTRL + SHIFT + DOWN

    2. same as the other step 2

    3. press =A1

    4. press CTRL + ENTER to fill them together

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Avoiding Copy & Paste in Hidden/Filtered Cells
    By garrett.grillo in forum Excel General
    Replies: 5
    Last Post: 02-24-2014, 04:45 PM
  2. [SOLVED] Copy and Paste Filtered Data
    By r5swank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2012, 11:36 AM
  3. Replies: 3
    Last Post: 08-28-2012, 10:09 AM
  4. Copy and paste filtered data
    By owentc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2010, 11:05 AM
  5. Copy and Paste on Filtered cells
    By rlkerr in forum Excel General
    Replies: 2
    Last Post: 06-24-2009, 02:39 PM

Tags for this Thread

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