+ Reply to Thread
Results 1 to 2 of 2

Compare data in two tables and extract matching values to a third table

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Durham, NC
    MS-Off Ver
    Excel 2003
    Posts
    8

    Compare data in two tables and extract matching values to a third table

    I have data in two tables, which are entered by the user. I'm hoping to have a third table which extracts matching records from the first two tables as shown in the attached example. I'd like the third table to be updated whenever user selects an "update" button.
    Attached Files Attached Files

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Compare data in two tables and extract matching values to a third table

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ 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] compare Two Tables - A and B - and Return the Values of Table A
    By Alienontherun in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-28-2018, 12:33 PM
  2. [SOLVED] Compare Two Tables and Return Values Only on Rows that Match the other Table
    By Alienontherun in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-27-2018, 06:41 AM
  3. Replies: 1
    Last Post: 07-07-2018, 02:52 AM
  4. How to extract DOB values from data and then compare them ?
    By Ashlaad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2018, 11:58 AM
  5. [SOLVED] Compare two columns, and extract not matching data in third
    By patko15 in forum Excel General
    Replies: 2
    Last Post: 06-08-2016, 06:11 AM
  6. Replies: 30
    Last Post: 08-17-2015, 01:18 AM
  7. Replies: 1
    Last Post: 12-25-2011, 08:19 PM

Tags for this Thread

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