Mark,
Why didn't you say you wanted the filter criteria to be pulled from a cell? What cell will it be pulled from? What is the data that will be in the cell?
Also, from your original post:
I want to autofilter that column so that it automatically shows only records after the 1st July 2013
And from your most recent post:
Also by using the >= operator it will pick up data from any month after July 2013 I just want data from a specific month in a specific year
That is easily accomplished, but things would go a lot easier if you would explain these things ahead of time
Assuming the user is entering the following into sheet 'Lookup' cell A1 and that cell is formatted as General when they do so:
"July 2013"
Excel will convert that into a date value of Jul-13 automatically. This VBA code can be used to set the filter:
Bookmarks