Hi all,

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

Basically I have an interface (sheet 1) with drop down boxes and go buttons.
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 boxes 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 list

How do I do that???

THEN I want to be able to pick a name from the drop down box on sheet 1 and when I press the go button, filter this on sheet 2. Also the go button should take me to sheet 2 and show me the filtered Column A based on the chosen name

Please help, I think it is simple code :~