+ Reply to Thread
Results 1 to 2 of 2

Extract data from one list to a new table based on dynamic criteria

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    22

    Extract data from one list to a new table based on dynamic criteria

    Hi Again,

    Hope you are all well and safe.

    I need assistance to create an ongoing list that will pull data from one list based on cretiria from a second list. Both lists will have new rows every day

    The first tab is list of insurance call center calls with information about the call - time, subject, claim number etc.
    The second tab is a list of the claims we want to track if we had related calls.
    More calls and claim numbers are been added to both lists every day
    What I want to show as a result is a daily dynamic table that will include all the information of the calls related to the claims on the list

    Hope it's clear - I added example of the output

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Extract data from one list to a new table based on dynamic criteria

    Just add a column of formulas to your first table, and filter it to show the values of interest, as in the attached:
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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] Extract data from table based on criteria applied to multiple columns
    By Feremartinez in forum Excel General
    Replies: 9
    Last Post: 11-21-2018, 12:34 PM
  2. want to extract most recent data from a list based on two criteria
    By cnak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2018, 03:31 PM
  3. [SOLVED] Filter and extract list of data based on criteria using INDEX MATCH
    By brake in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-13-2018, 08:30 AM
  4. [SOLVED] Need a lookup to extract data table based on four criteria & override user input
    By Marvelous in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-01-2013, 12:54 PM
  5. [SOLVED] Create Dynamic Data Validation List based upon Criteria
    By stubbsj in forum Excel General
    Replies: 6
    Last Post: 06-04-2012, 08:33 AM
  6. Replies: 3
    Last Post: 08-21-2011, 08:22 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