Results 1 to 10 of 10

Filter Array 1 with Array 2 as criteria, returning filtered data to source sheet

Threaded View

nigelog Filter Array 1 with Array 2... 01-31-2019, 10:13 AM
Fluff13 Re: Filter Array 1 with Array... 01-31-2019, 10:40 AM
nigelog Re: Filter Array 1 with Array... 01-31-2019, 11:07 AM
nigelog Re: Filter Array 1 with Array... 01-31-2019, 11:37 AM
Fluff13 Re: Filter Array 1 with Array... 01-31-2019, 11:50 AM
nigelog Re: Filter Array 1 with Array... 01-31-2019, 12:10 PM
nigelog Re: Filter Array 1 with Array... 01-31-2019, 12:18 PM
Fluff13 Re: Filter Array 1 with Array... 01-31-2019, 12:28 PM
nigelog Re: Filter Array 1 with Array... 01-31-2019, 12:47 PM
Fluff13 Re: Filter Array 1 with Array... 01-31-2019, 01:08 PM
  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Filter Array 1 with Array 2 as criteria, returning filtered data to source sheet

    I have been trying to replace a group of macros in a workbook here because they are slow due to the shear volume of data. I posted an earlier attempt which filtered the data twice but because if read the filtered ranges cell by cell into a holding array it was too slow.
    I have my two arrays "Var" and "vaData" but cant think of a course to take from here. Any pointers or suggested methods appreciated

    Sub FilterArr()
    Dim lng1, lng2, Lrow As Long
    Dim rng As Range
    Dim vaData, Var As Variant
    Dim ws As Worksheet
    Set rng = Sheet2.Range("P1:P" & Cells(Rows.Count, "P").End(xlUp).Row)
    Set ws = Sheet1
    With ws
    Lrow = .Range("a" & Rows.Count).End(xlUp).Row
    
    Var = .UsedRange.Value
        For lng1 = LBound(Var, 1) To UBound(Var, 1)
            For lng2 = LBound(Var, 2) To UBound(Var, 2)
            Next lng2
        Next lng1
    ''''Array created
    
        vaData = rng.Value
    
    ''''Advanced Filter range is "rng"
    
    
    
    ''''Filter Var using vaData as criteria
    
    '>>>>>>>Write array back to source sheet once cleared
    End With
    End Sub
    Attached Files Attached Files
    Last edited by nigelog; 01-31-2019 at 01:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-22-2018, 01:47 AM
  2. [SOLVED] match() an array filtered based on criteria in another column
    By simarui in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2014, 03:32 PM
  3. Replies: 4
    Last Post: 12-23-2013, 08:43 AM
  4. Replies: 19
    Last Post: 05-09-2012, 03:31 AM
  5. Filter sheet then assign values into array based on this filtered sheet
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2011, 10:32 AM
  6. Returning Data from an array only if it meets certain criteria
    By Jantzev in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2008, 07:57 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