+ Reply to Thread
Results 1 to 2 of 2

How to copy/paste visible cells only? (found the answer online)

  1. #1
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    678

    How to copy/paste visible cells only? (found the answer online)

    Attached: If I have a table, and filter the table based on column C. Now in the filtered rows, I would like to copy B2 to A2, and copy B5 to A5, but if I select B2 and B5 at the same time, it ends up I copy B2/B5 to A2/A3.

    The output I expect should be: A2=11; A3=2; A4=3; A5=44

    The reason is I don't want to copy one cell at a time, I want to copy a lot of cells in the filtered table, and paste them in same rows.

    Thanks.


    Copy and Paste.PNG
    Last edited by VAer; 01-24-2017 at 09:46 AM.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to copy/paste visible cells only?

    Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

    If you need to post an image post it in the *.jpg format.

    Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Copy to Paste the Sum of the Selected VISIBLE Cells
    By Enright in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2016, 11:22 AM
  2. Copy/paste visible cells only?
    By Royser12345 in forum Excel General
    Replies: 3
    Last Post: 03-02-2014, 01:52 PM
  3. [SOLVED] Copy and Paste Visible Cells Only to another Worksheet
    By excelnoob808 in forum Excel General
    Replies: 8
    Last Post: 05-30-2013, 03:28 PM
  4. Copy & Paste visible cells only
    By klopatios in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-06-2013, 03:59 AM
  5. Copy Visible cells and paste values only to visible target cells
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2010, 04:09 AM
  6. Copy and Paste Visible Cells
    By Lost and Looking for Help in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2006, 10:20 AM
  7. [SOLVED] Copy & Paste visible cells only
    By Scott in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2005, 12:06 PM

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