Custom Autofilter

[RunrChic01]

I've imported data into Excel from an Access database. I've applied the autofilter feature. Now I need to filter according to date. When you click the custom option under the Date filter, I am able to either select or manually type in the date range that I am seeking. Is there anyway to make that date a specific cell? So that someone might be able to put the criteria into that cell and hit a macro button that will automatically filter the date according to a specific date range as stated in specific cells?



ANY information would be helpful!

[VBA Noob]

Without code I would suggest using advance filters

http://www.contextures.com/xladvfilter01.html

or here's an example with code and some links

http://www.ozgrid.com/VBA/autofilter-vba-dates.htm

http://www.oaltd.co.uk/ExcelProgRef/...rogRefCh22.htm

VBA Noob