Morning All,
I have a list of my staff's current locations and I want to extract a specific location based on user input from a dropdown list and add it to a new list.
Sheet 1 contains the location of all staff, while Sheet 2 should display only the staff based on the selected location. I have tried various methods, but have been unsuccessful.
I have a list of my staff's current locations and I want to extract a specific location based on user input from a dropdown list and add it to a new list.
Sheet 1 contains the location of all staff, while Sheet 2 should display only the staff based on the selected location. I have tried various methods, but have been unsuccessful.