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. |
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. |
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. |
All times are GMT +1. The time now is 12:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com