I need to have a drop down box based on data in a worksheet. On a separate sheet I have a grid that I want to autopopulate with all the data that contains the value in the drop down box. The number of rows that will populate will vary.
So, how do I capture all the data based on a value and fill in excel cells and only the rows with data should be displayed.
Attached is a copy of the grid