Results 1 to 5 of 5

Advanced Filter - Pasting two sets of data into the same sheey

Threaded View

williamsm96 Advanced Filter - Pasting two... 07-19-2019, 06:43 AM
AliGW Re: Advanced Filter - Pasting... 07-19-2019, 07:00 AM
williamsm96 Re: Advanced Filter - Pasting... 07-19-2019, 07:45 AM
JeteMc Re: Advanced Filter - Pasting... 07-22-2019, 07:14 PM
Akuini Re: Advanced Filter - Pasting... 07-22-2019, 08:53 PM
  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Coventry
    MS-Off Ver
    2016
    Posts
    13

    Advanced Filter - Pasting two sets of data into the same sheey

    Hi,

    I've created the below macro that uses the advanced filter to filter and copy two sets of data from different sheets into one sheet. However the second set of data pastes over the first because the CopyToRange is the same. How can I change the CopyToRange of the 'Detailed Reg' to be the next empty row?

    Sheets("Test").Range("A20:S1048576").AdvancedFilter Action:=xlFilterCopy, _
            CriteriaRange:=Sheets("Test").Range("Q17:Q18"), CopyToRange:=Range("A1:S1") _
            , Unique:=False
        Sheets("Detailed Reg").Range("A2:S1048576").AdvancedFilter Action:= _
            xlFilterCopy, CriteriaRange:=Sheets("Test").Range("P14:P15"), CopyToRange:= _
            Range("A1:S1"), Unique:=False
    Thanks
    Last edited by AliGW; 07-19-2019 at 07:00 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  2. Replies: 14
    Last Post: 01-17-2017, 06:39 PM
  3. Copying columns of 10 data sets and pasting them into a new sheet
    By novious1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2015, 10:59 PM
  4. Copying Specific Data sets and pasting them in Columns of 10
    By novious1 in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-15-2015, 11:15 PM
  5. Using Array for advanced filter terms and then pasting a corresponding value
    By hblauth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2013, 05:39 AM
  6. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  7. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 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