Can I use a macro to autofilter in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
How can run a macro ( call a macro) on selection of any filtercriteria? 7
Macro to copy value in field and insert it into filter 2
Autofilter using cell reference 2
Excel Macro to use cells as a autofilter 0
Average over autofilter results 4
Counting Filtered Results Using Autofilter 2
emailing autofilter results 3

Back
Top