Hello,

New here. I was wondering if anyone had a dynamic way to hide drop-down items that can selected from different sheets?

Example: List of company EEs assigned to different projects. Each sheet would be a separate project. There is a master EE list to reference for drop-down list. I can get it to filter on single sheet using COUNTIF function. Attempting to use VSTACK, just need a little help.

Any suggestions?

Thanks,

Morgan