Results 1 to 7 of 7

Extracting rows of data based on multiple criteria from a list

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    365
    Posts
    63

    Extracting rows of data based on multiple criteria from a list

    I am looking to pull multiple peoples data from a larger data set based on selecting their name from a drop down list. This drop down list will allow for multiple people to be selected and if so it will pull the data for all that are selected in the list.

    in the sample file when names are selected in the drop down cells from B2:B6 it will pull all the data that matches the names in the large data set in columns M:P
    it will then populate column D:G

    The data doesn't necessarily have to be in any order but it just needs to be complete
    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. [SOLVED] Merge multiple sheets data into 1 sheet based on multiple criteria (List Based)
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 08-10-2018, 11:08 AM
  2. [SOLVED] Calculating list data based on multiple criteria
    By squigman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2013, 07:35 PM
  3. [SOLVED] Extracting A Continuous List Based On Criteria HELP req...
    By chandu356 in forum Excel General
    Replies: 7
    Last Post: 11-15-2013, 09:22 AM
  4. [SOLVED] Extracting certain rows based on multiple criteria
    By Nurik in forum Excel General
    Replies: 6
    Last Post: 10-30-2013, 02:05 PM
  5. Extracting sublist from list based on criteria
    By frichmond in forum Excel General
    Replies: 16
    Last Post: 09-19-2013, 02:13 AM
  6. Extracting a continuous list based on criteria
    By bungaree in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2009, 07:49 PM
  7. Extracting rows based on fixed criteria
    By EdMac in forum Excel General
    Replies: 6
    Last Post: 07-06-2006, 02:10 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