Hi All,

I'm after a macro to that chooses a value from a filter drop down based on a value a user enters in a cell.

EG: There is a list of values in column B (say B1:B100). This list has an auto filter applied. A user enters "3" in cell A1 and runs the macro. The macro selects "3" from the drop down to filter the list.

Any thoughts/suggestions would be appreciated.

(note: the user cannot choose the value themselves from the drop down.)

CHEERS