Autofilter in VBA using a drop down list for criteria

[MOONDRIFT47]

Hi,
I have this code at the moment and I want the search criteria to be either a cell reference or from a drop down list. Not sure how to write the end bit. At the moment it says Mike so it will only show his name, but I want the user to be able to select any name from a list. How do I do that?

Thanks

Please Login or Register  to view this content.

[jeffreybrown]

You should be able to use...

Please Login or Register  to view this content.

[MOONDRIFT47]

Thanks, slowly getting the hang of this.

[jeffreybrown]

You are very welcome