+ Reply to Thread
Results 1 to 3 of 3

Copying large range of data into filtered cells

  1. #1
    Registered User
    Join Date
    03-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    29

    Copying large range of data into filtered cells

    I have a spreadsheet with thousands of rows which is currently filtered to hide duplicate rows.

    I now wish to copy a large set of data into a column when it is already filtered and for the values to be updated in the visible cells when filtered (so that when I remove filters), only a selection of the cells in that column contain values).

    At present, when I paste the data, it pastes into a range such as A2:A750 even if the majority of those cells are currently hidden/filtered.

    Please could anyone advise what I need to set in order to only paste range into filtered cells only?

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    03-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Copying large range of data into filtered cells

    I thought I had found a solution to this, but I haven't (so deleted what this previously said).
    Last edited by zigojacko; 04-15-2013 at 10:57 AM.

  3. #3
    Registered User
    Join Date
    03-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Copying large range of data into filtered cells

    I now have found a solution with this macro.

    Select the range of cells you wish to copy, view code entering the below macro.

    Please Login or Register  to view this content.
    Hit Alt+F8 to bring up the macro's screen, and run the macro Copy_Filtered_Cells - select the range you wish to paste to (where your data is filtered).

    This will then only paste values to the filtered (visible) cells.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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