+ Reply to Thread
Results 1 to 3 of 3

Extract data with one criteria and no duplicate

  1. #1
    Forum Contributor
    Join Date
    12-01-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 365
    Posts
    109

    Extract data with one criteria and no duplicate

    Dear All,

    If i want to exctract data from worksheet "LIST" in column Item with certaint criteria in column Month and show the extracted data with no duplicate in worksheet "ectdata" starting from cell B7, is it possible to do this task with VBA? So everytime we change the criteria in worksheet "ectdata" on cell B4, tha list will be change accordingly.

    For more detail I attach the Excel data.

    Thank you for your kind helping.

    Omegaboost
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Extract data with one criteria and no duplicate

    Try
    Please Login or Register  to view this content.
    Last edited by jindon; 04-02-2016 at 03:30 AM. Reason: Code has been replaced.

  3. #3
    Forum Contributor
    Join Date
    12-01-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 365
    Posts
    109

    Re: Extract data with one criteria and no duplicate

    Dear Jindon,

    Thank you for your code.

    You're the best

    Edo

+ 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] need code to extract duplicate data into another row
    By Jocote46 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-31-2015, 03:57 PM
  2. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  3. Extract data based on criteria
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-15-2014, 05:23 PM
  4. Extract data using two variables or criteria
    By uniqbboy in forum Excel General
    Replies: 2
    Last Post: 09-09-2014, 11:59 AM
  5. Replies: 2
    Last Post: 11-27-2013, 12:48 AM
  6. Extract data with 2 criteria
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2012, 06:48 PM
  7. [SOLVED] Extract data based on 1 criteria
    By TexasRhode in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2012, 06:08 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