+ Reply to Thread
Results 1 to 4 of 4

Filter data from a Master sheet based on multiple criteria by VBA code

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    150

    Filter data from a Master sheet based on multiple criteria by VBA code

    Hi All,

    I need a vba code for this below problem, i have attached a sample file.

    I have a master sheet with data, In the second sheet i have criteria selection, based on criteria, data should be filtered according to the field selected from the master sheet.

    The format and the grand total should get adjusted based on the data filtered.
    The S.No should be count based on the data filtered.

    Any help much appriciated.

    Many Thanks
    Jude
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Filter data from a Master sheet based on multiple criteria by VBA code

    NON VBA solution.

    with index / match (in combination with several helpcolumns.

    See the attached file.

    Please reply if this is the result your expecting.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    08-19-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    150

    Re: Filter data from a Master sheet based on multiple criteria by VBA code

    Hi Oeldere,

    Thanks for the reply, I have a formula solution, but the challenge is grand total row should be adjusted according to the data rows, thats the reason i need an vba solution.

    Thanks
    Jude

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Filter data from a Master sheet based on multiple criteria by VBA code

    NON VBA solution.

    with an filter on sheet 2.

    see the attached file.
    Attached Files Attached Files

+ 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. Copying Data error from master sheet based on Range criteria
    By naga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2013, 02:11 AM
  2. [SOLVED] Filter and export to a new sheet based upon multiple criteria
    By Cody1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2012, 07:03 PM
  3. VBA Code for Multiple criteria auto Filter & sending the mails based on that
    By Rajveer1981 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2012, 01:37 PM
  4. Filter based on multiple criteria in other sheet
    By prashantsd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2012, 09:08 AM
  5. Replicating data from master sheet based on 2 criteria
    By kate8301 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2011, 07:10 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