I'm not a VBA expert and need help with a VBA script as I believe the normal AutoFilter cannot achieve what I want.
I have an Excel spreadsheet with a dropdown list of names of staff in cell A1.
You pick a staff name from the dropdown list and it is set in A1.
Below is a number of rows : A2 to A100
On each row column A has the same dropdown with one of the staff names pre-selected or left blank
On each row column B has the same dropdown with one of the staff names pre-selected or left blank
On each row in column C is a string of text
What I want to achieve is that you can choose a staff name on A1 .. and it will then filter rows 2 to 100 and look in the values in A & B that contain that staff name to only show those matching A or B rows which contain the staff name in A1.