Anything that will let us know what you're trying to achieve more so than how you're trying to achieve it will help us help you.



Currently, don't know what you mean by 'drop down'.... there's combo box or data validation

I've currently attached the Excel workbook that I am trying to use for this. If you click on the first tab, named Card, you can see that I've organized some groups with names. Ideally, there would only be one cell which would contain all of these sheet names, and, depending on which one you select (from a dropdown), it would change the list values in a second dropdown which would be based off of the Person row in each of the sheets.

I'm also running into another issue where Ignore Blanks isn't working. I tried including a sample dropdown.

Attached Files

mwcil-Resource-Contact List.xlsx (61.2 KB, 12 views)