Hi all,

Im looking to create an interface for a worksheet in excel.

Basically I have an interface (sheet 1) with drop down boxes.
In sheet 2, Column A has a list of names i.e. "J Smith", "R Peach" ETC

What I want to do is for one of the drop down box to go to "sheet 2" and select all the data in Column A, auto filter it so that there is only one instance of each name and bring that into the drop down box

The I want to be able to pick a name from the drop down box on sheet 1 and filter this on sheet 2

Please help, I think it is simple code :~