Attached is a spreadsheet.
There are two drop down menu's in column G and I.
The users of the worksheet have no understanding of filtering what so ever so the aim is to make it as user friendly as possible.
I would like it so that when a value is selected from the drop down this changes the filtered results in the table.
For example when "Angela Elvin" is selected from the drop down in cell G3 then column A will display the rows for "Angela Elvin" only
Likewise when "complete" is selected from the drop down in cell I3 then column E will display the rows for "complete" only
I have added a value to each of the drop down lists which don't appear in either or the corresponding filter columns. The rules for these values have been explained and highlighted in pink on the worksheet.