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.
Bookmarks