Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel application.quit in macro problem | New Users to Excel | |||
Excel macro | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |