Advanced Filter Defaults
VBA might be the way to do this, but I'm hoping for a simper solution. Each
time I change the criteria for my advanced filter I need to select the copy to range. Is there a way to make this the default selection? Also, is VBA the only way to make the Advanced Filter run whenever the criteria is changed. Thanks for any help. |
Advanced Filter Defaults
If you create a range named Extract, that should be selected by default.
There are instructions here for naming a range: http://www.contextures.com/xlNames01.html And you'd need programming to make an advanced filter run automatically. Bob wrote: VBA might be the way to do this, but I'm hoping for a simper solution. Each time I change the criteria for my advanced filter I need to select the copy to range. Is there a way to make this the default selection? Also, is VBA the only way to make the Advanced Filter run whenever the criteria is changed. Thanks for any help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Advanced Filter Defaults
Thanks Debra.
"Debra Dalgleish" wrote: If you create a range named Extract, that should be selected by default. There are instructions here for naming a range: http://www.contextures.com/xlNames01.html And you'd need programming to make an advanced filter run automatically. Bob wrote: VBA might be the way to do this, but I'm hoping for a simper solution. Each time I change the criteria for my advanced filter I need to select the copy to range. Is there a way to make this the default selection? Also, is VBA the only way to make the Advanced Filter run whenever the criteria is changed. Thanks for any help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 10:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com