+ Reply to Thread
Results 1 to 6 of 6

Filter for Two Criteria and Unique list copy another sheet

  1. #1
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    233

    Filter for Two Criteria and Unique list copy another sheet

    Hi friends,

    I am looking for a VBA code line for filtering for two criteria (one criteria in B column and E column second).

    After filtering Unique values which will be in A column & E Column should copy to another sheet (name Data) from B2.

    Can anyone suggest code lines?

    Regards, RL
    Last edited by rr1050; 07-27-2014 at 02:33 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,474

    Re: Filter for Two Criteria and Unique list copy another sheet

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    233

    Re: Filter for Two Criteria and Unique list copy another sheet

    extract_data_using_advanced_filer_with_vba.xlsm

    While I am seaching filter code, I found on Chandoo.ord one file (attach), which is good to understand multiple criteria filtering.

    But how I can get unique list (no duplicates) from heading "Caller ID". After unique list I would like to get copy only "Caller ID" and respective "Satisfaction Ratio" to another sheet.


    Note:- As I found the excel file so I changed my query relatively so I can adjust same ways.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,474

    Re: Filter for Two Criteria and Unique list copy another sheet

    Here is a tutorial on Unique filtering

    http://office.microsoft.com/en-us/ex...010073943.aspx

  5. #5
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    233

    Re: Filter for Two Criteria and Unique list copy another sheet

    This I know for sure, but how to do by VBA?

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,474

    Re: Filter for Two Criteria and Unique list copy another sheet

    A good way to learn is to use the record Macro wizard built into Excel. Then modify it for the variables. If after using the record macro and you have issues, post your code with an explanation of your issues and we will assist. I would do the filter for the unique items on the already filtered data you have. Give it a try, and you will be surprised how much you can accomplish this way.

+ 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. [SOLVED] Loop through Auto Filter Criteria and Copy Formula Results Into New Sheet
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-21-2014, 05:34 PM
  2. [SOLVED] Copy Cell based on unique value from another sheet from a list
    By hollyspetshop in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-08-2012, 03:10 PM
  3. Filter multiple criteria to only keep unique values
    By albardit18 in forum Excel General
    Replies: 2
    Last Post: 05-10-2012, 09:38 AM
  4. Return Filter Criteria for each Unique Value in Range
    By hartwm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2011, 10:18 AM
  5. Advanced Filter - unique cell value as one of the criteria
    By efm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2010, 03:43 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