Hi,

I am working on a macro that will filter according to date. The data needs to be filtered to show dates in a fiscal year; that is from April 1, yyyy to March 31, yyyy+1. i.e., April 1, 2012 to March 31, 2013.

I would lke this macro to allow for input either from 2 cells that can be referenced on the sheet, or through an input box. The other option that I don't think is available, is to adjust the "current year", "last year", and "next year", which are options in the filter menu so that they use the fiscal dates rather than the calendar dates.

Thanks