Shortcut for Filter- Custom Autofilter

E

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
 
D

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
 
Top