Can I use a macro to autofilter in excel
 

I have a list of work completed over a 24 hour period. I need to filter out
all work completed each hour. I have used autofilter, but at present need to
use this function for every different hour, if i use a macro, the subtotal
changes to the filter I'm inputting. Can i use a macro to perform this
tedious task?

Can I use a macro to autofilter in excel
 

It is possible, even fairly simple, but can you give an example of the data
and how you filter, as that is not clear from your post.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"priceyindevon" wrote in message
...
I have a list of work completed over a 24 hour period. I need to filter
out
all work completed each hour. I have used autofilter, but at present need
to
use this function for every different hour, if i use a macro, the subtotal
changes to the filter I'm inputting. Can i use a macro to perform this
tedious task?