Shortcut for Filter- Custom Autofilter
 

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Eileen" wrote in message ...
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

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

Eileen wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html