Shortcut for Filter- Custom Autofilter

[Eileen]

I use Custom Autofilter (Autofilter-pull down-custom...)on
daily basis. Is there a way I can create shortcut or
toolbar for this command?

Thanks

 

[Ron de Bruin]

Hi Eileen

Not that I know of.
But maybe you like my Filter ADD-in to do what you want
http://www.rondebruin.nl/easyfilter.htm

 

[Debra Dalgleish]

If you always filter on the same column, e.g. Invoice Date within a
certain range, you could add a new column to your table.

In that column, test the invoice date against a Start and End date that
you enter at the top of the worksheet. For example, if Invoice date is
in column A, Start date is in cell L1, and End date is in cell M1:

=AND(A2>=$L$1,A2<=$M$1)

Copy the formula down to the last row of data

Each day, you could change the start and end dates, then filter the new
column for TRUE