Results 1 to 12 of 12

Match ID from Two Sheets and Display Unique ID in List Box

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    332

    Match ID from Two Sheets and Display Unique ID in List Box

    Hello Friends how are you?

    I am struck with a problem........

    I have a workbook which Contains Two Sheets i.e. Sheet1 (Master Data) and Sheet2

    I have some ID in Sheet2 ID (Column A).........i want to match Sheet2's ID from Sheet1's ID.........and display only unique IDs records of Sheet2 in listbox

    for example:-
    In Sheet2 ID No. 110 exist in Sheet1 also, this record should not be display in Listbox
    In Sheet2 ID No. 120 not exist in Sheet1, so this ID's Data should display in Listbox


    I want to make it dynamically so the data in future increase or decrease

    When i Click on 1st Command Button (display only unique IDs records) It shows the only data of Sheet2's ID which not exist in Sheet1......

    after that Listbox contains unique record of sheet2 which does not exist in Sheet1

    When i click on Commandbutton2 (Export to Excel) it create a folder in Drive D namely Report Folder and save the listbox's result in excel file "report generate on Current Date (01.10.2017)

    please help me to write a code for me................
    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. Display the unique word from a list
    By john dalton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2016, 09:21 AM
  2. [SOLVED] Index:Match to display unique instances only
    By mitch1976 in forum Excel General
    Replies: 16
    Last Post: 01-27-2016, 04:12 PM
  3. Replies: 7
    Last Post: 06-27-2014, 02:26 AM
  4. Need to display Unique Values in a list and return them
    By citibond in forum Excel General
    Replies: 4
    Last Post: 04-26-2012, 12:34 AM
  5. Replies: 5
    Last Post: 08-26-2008, 01:07 PM
  6. Combo Box - Display Unique Items in List
    By Gary S in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2007, 11:15 AM
  7. Display Unique Names From a Long List
    By Phillycheese5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2007, 07:06 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