I don't seem to be able to create a macro that will run an auto filter.

i.e. I enter data on sheet 1, the data is linked to sheet 2. I have an autofilter set yup to filter the data, but I would like to create a macro that will select a predetermined value of the filter list data and run the filter.

I know that its not a big step to push the little down arrow and select the value manauly. It would just be a nice little feature to add to the workbook.

Thanks in advance.