+ Reply to Thread
Results 1 to 2 of 2

Copy Paste to visible cells only with different filters in different sheets / workbooks

  1. #1
    Registered User
    Join Date
    08-25-2017
    Location
    Cambridge, England
    MS-Off Ver
    2013
    Posts
    1

    Question Copy Paste to visible cells only with different filters in different sheets / workbooks

    Hi everyone !

    Thanks to anyone affording time to read this and possibly help


    Here is my issue :

    I'd like to copy data from a filtered column, then paste it to a filtered column in a different sheet, or even a different workbook.

    I have a macro that works perfectly well to do that in single sheet. But excel crashes if I try to use it to paste in a different sheet or workbook.


    Any idea of a way around ?


    To enlighten my issue, I here enclose a file :

    The column "Count 1" in Sheet 1 is filtered so that blank cells aren't visible.

    I'd like to copy visible cells from "Count 1" in Sheet 1 and paste them in the column "Count 1" inthe Sheet 2 where different rows are filtered (because of filtered data / blanks cells in "Count 2")

    Again, any solution working for different sheets would be awesome, but any solution solution working for different workbooks would be even better !

    Here the code I use that only works in a single sheet :

    Please Login or Register  to view this content.
    Thanks again for your time !
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Copy Paste to visible cells only with different filters in different sheets / workbook

    hmm i cant seem to crash the sheet in your example
    so it works as intended with different sheets ?

    i do note that with inputbox to define the rngtopasteto...i cannot select a different workbook
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] loop copy & paste visible Ws only without hidden sheets to new Wb
    By Pi* in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2017, 11:42 PM
  2. How to copy/paste visible cells only? (found the answer online)
    By VAer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2017, 09:40 AM
  3. Copy/paste visible cells only?
    By Royser12345 in forum Excel General
    Replies: 3
    Last Post: 03-02-2014, 01:52 PM
  4. Copy And Paste visible Sheets and from second worksheet
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2013, 03:59 AM
  5. Copy & Paste visible cells only
    By klopatios in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-06-2013, 03:59 AM
  6. 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
  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

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