Someone asked me how to make a data validation drop down that only shows the visible rows from a filtered list. I created a sample file that shows how you can