Results 1 to 4 of 4

Create name list from multiple sheets based on drop down selection

Threaded View

  1. 03-27-2020, 03:40 PM #1
    kelwea
    kelwea is offline
    Registered User
    Join Date
    03-27-2020
    Location
    texas
    MS-Off Ver
    2013
    Posts
    2

    Post Create name list from multiple sheets based on drop down selection

    Hello everyone! PLEASE HELP!!

    In the attached sample spreadsheet I have created a drop down list in "DET TOTAL L2" based on the categories (row 2) in the other 5 sheets (HQ,FC,LCHR,EW,SIG). I am looking for a formula that will compile the names from each sheet that match the criteria of the dropdown list into column M. I was thinking INDEX/MATCH but not sure. Thank you in advance!

    Kelly Weaver
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. "VBA code to hide/show rows based on multiple selection of drop down list.
    By NASANASA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2020, 05:07 PM
  2. [SOLVED] Create a dependant drop down list based on multiple entries with the same name
    By heidzhaydz in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-15-2019, 04:12 AM
  3. [SOLVED] create a drop down which allows multiple selection and change content of table based on th
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 08-16-2015, 06:12 AM
  4. Need Macro to change selection on drop down list on multiple rows based on entry in cell
    By komo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2015, 07:29 AM
  5. [SOLVED] Returning data across multiple sheets based on drop down list selection
    By rooboyz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2014, 02:41 AM
  6. macro for printing sheets based on drop-down list selection
    By carrollkm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2013, 10:36 PM
  7. Multiple results to display based on selection made from drop down list
    By scoot_eruk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 05:03 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1