Create name list from multiple sheets based on drop down selection

**kelwea** · 03-27-2020, 03:40 PM

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

**Paul** · 03-27-2020, 04:27 PM

Hi Kelwea, see the attached sheet with macro. Hope that helps.

Please Login or Register  to view this content.

**kelwea** · 03-27-2020, 05:52 PM

Thank you so much for the response. That seems to work great, however my work disables macros and we are not able to use them on my work computer. Is there a formula set that can do this same thing?

**Paul** · 03-28-2020, 02:09 AM

I highly doubt any formula will do this for you. It would likely take a series of formulas to gather the needed info from multiple sheets, and then more to organize them into a list.

Create name list from multiple sheets based on drop down selection

LinkBack

Thread Tools

Rate This Thread

Display

Create name list from multiple sheets based on drop down selection

Re: Create name list from multiple sheets based on drop down selection

Re: Create name list from multiple sheets based on drop down selection

Re: Create name list from multiple sheets based on drop down selection

Thread Information

Users Browsing this Thread

Similar Threads

"VBA code to hide/show rows based on multiple selection of drop down list.

[SOLVED] Create a dependant drop down list based on multiple entries with the same name

[SOLVED] create a drop down which allows multiple selection and change content of table based on th

Need Macro to change selection on drop down list on multiple rows based on entry in cell

[SOLVED] Returning data across multiple sheets based on drop down list selection

macro for printing sheets based on drop-down list selection

Multiple results to display based on selection made from drop down list

Bookmarks

Bookmarks

Posting Permissions