| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advance filtering Update
I have just learn to use advance filter but not succedd to update table when
I change the filter field... Is there a way to do it automaticaly instead of going into the data-filter-advance filter menu again? I appreciate any help I can get to make this happen. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Advance filtering Update
advance filter won't refresh automatically. Have you tried the auto-filter?
This will refresh when you change the criteria "Alberto Ast" wrote: I have just learn to use advance filter but not succedd to update table when I change the filter field... Is there a way to do it automaticaly instead of going into the data-filter-advance filter menu again? I appreciate any help I can get to make this happen. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Advance filtering Update
Thanks Patrick... I'll write a macro to update table then... I have a second
question regarding this filter... What will be the best option to filter up to 50,000 rows... when I do this filters it is not too slow to filter but takes too long to run when I clean the filter.... I tried with Application.ScreenUpdating = False and then back to true and it helps but not fast enough. "Patrick Molloy" wrote: advance filter won't refresh automatically. Have you tried the auto-filter? This will refresh when you change the criteria "Alberto Ast" wrote: I have just learn to use advance filter but not succedd to update table when I change the filter field... Is there a way to do it automaticaly instead of going into the data-filter-advance filter menu again? I appreciate any help I can get to make this happen. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternatives to advance filtering? | Excel Discussion (Misc queries) | |||
| Sorting data and Advance filtering to get totals on a spreadsheet | Excel Discussion (Misc queries) | |||
| Need advance filtering to grab records that contain certain charac | Excel Discussion (Misc queries) | |||
| advance filtering | Excel Discussion (Misc queries) | |||
| Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
![Alberto Ast[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
