Results 1 to 5 of 5

Code to filter Sub Array from data set

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    Office 365
    Posts
    447

    Code to filter Sub Array from data set

    Hi,

    Im trying to filter a subarray from a data set using 2 criteria.
    In the Data sheet I have the data and in cells G3 and G4, I have the criteria for company and marks which will be used to filter the data

    I require the simplest code to filter the data using the entered criteria and paste into a new sheet ( "Result") sheet

    I know how to do this using formula but require a VBA solution.

    Also would require an error control if entered criteria is not found in the data set.


    Thanks in advance.Sample sheet attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter Data with an Array Formula
    By myobreportguru in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2016, 05:02 AM
  2. Cannot filter data that is part of an array
    By haulinbass in forum Excel General
    Replies: 1
    Last Post: 06-11-2016, 06:13 PM
  3. VBA Function to filter data from an array
    By car___ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2014, 04:31 PM
  4. [SOLVED] Filter data using Array Function
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-23-2014, 08:45 AM
  5. [SOLVED] Filter Data with Array
    By jkj115 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-19-2013, 04:22 PM
  6. VBA code to filter data
    By Knigtandday in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2013, 05:36 PM
  7. [SOLVED] VBA code to filter data
    By Pelham in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2006, 12:30 AM

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