Here's a dummy workbook of what I'm doing.
Basically I want users to be able to perform advanced filtering without having to write up the criteria. So I made this in place of that...I know it's extensive....but It's much easier than teaching the users about advanced filtering
The way I have what I'm asking for now will filter for the months of the criteria fields, instead of specific dates. You'll see what I'm talking about.
Tell me what you think, too....I may submit something like this as a KB entry
EDIT:
Lemme give a little description about what happens....
User will only see three sheets: Forecast, Actual, Results
When users press the "Advanced Filter" button, the userform will show up. The form will have all unique values for filtering. The top frame in the form is for text, and the bottom for date values. When the user selects what they want to filter and presses "Filter", the form will make a layout of the criteria on the sheet "Criteria". It also makes a seperate layout for the "Results" sheet (because of my problem) because it needs a different layout for the dates. When the user selects the "Month" option (which will filter for the month asked for)...this poses no problem for my filter. The "Dates Between" is what is the problem...and the way I have it now is similar to the "Months" option....except when the user enters "Start Date" and "End Date" the procedure I wrote will only use the months of those values to filter (which is not exactly accurate).
And that is a little more of an explanation. I hope it is enough.