I have a lot of data saved onto a worksheet and would like to make it simpler to search and find things in it. What I am looking for is to use a drop down menu with several options that search the D column for matching data and then use a second drop down box that searches column C in the same worksheet that allows me to search within the results from the first drop down box to populate another worksheet in the same workbook. How can I do this?