+ Reply to Thread
Results 1 to 4 of 4

paste range to visible cells

  1. #1
    Registered User
    Join Date
    09-16-2019
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    20

    paste range to visible cells

    Can I paste a range in visible cells?

    I can paste on visible cells only if I'm pasting the same value for all visible cells or if the copied region is the same row with the paste region (through cell reference), but i can't find how to paste a range.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,478

    Re: paste range to visible cells

    As this is a filtered range you could do it using a macro. Run macro "FilterCopy" in uploaded xlsm file.

    If you can use a formula to do this??? I don't know how to do it that way but perhaps another forum member has the know-how.

    Alf
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,849

    Re: paste range to visible cells

    You can use a pivot table for this
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    790

    Re: paste range to visible cells

    Try this:

    Please Login or Register  to view this content.

+ 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 Visible Date and Paste into Visible Cells only
    By vikas_newports in forum Excel General
    Replies: 14
    Last Post: 07-01-2020, 01:43 PM
  2. Copy-Paste formatting of visible cells to visible cells
    By hansaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2018, 04:29 PM
  3. Replies: 0
    Last Post: 09-17-2017, 06:30 PM
  4. [SOLVED] paste to visible cells only
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2016, 09:31 AM
  5. Replies: 3
    Last Post: 04-09-2015, 07:42 PM
  6. [SOLVED] Copy Filter Data and paste it on another workbook with special cells(Only Visible Cells)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-13-2014, 07:59 AM
  7. 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

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