saving autofiltercustom filter settings
I'm using Excel 2003
I have a sheet which contains records from several employees, who list problems with customers. If I want to select all the problems one specific employee is handling, I can filter column A (where their names are) with customequals [name] How, if at all, can I preserve a number of settings for this filter? Can I create a dropdown list where I already have john, jack, amy, and ann as options? The same problem pertains to several other columns that contain discrete values. Thanks, Edwin |
saving autofiltercustom filter settings
Try Advanced Filter instead of Auto Filter.
"Edwin199976" wrote: I'm using Excel 2003 I have a sheet which contains records from several employees, who list problems with customers. If I want to select all the problems one specific employee is handling, I can filter column A (where their names are) with customequals [name] How, if at all, can I preserve a number of settings for this filter? Can I create a dropdown list where I already have john, jack, amy, and ann as options? The same problem pertains to several other columns that contain discrete values. Thanks, Edwin |
saving autofiltercustom filter settings
Maybe you could use ViewCustom Views.
Do your autofilter on John then name this Custom View as John. Continue with other autofiltering and name those views also. The filtered views will automatically adjust to encompass new entries in those categories. Gord Dibben MS Excel MVP On Wed, 13 Dec 2006 08:06:01 -0800, Edwin199976 wrote: I'm using Excel 2003 I have a sheet which contains records from several employees, who list problems with customers. If I want to select all the problems one specific employee is handling, I can filter column A (where their names are) with customequals [name] How, if at all, can I preserve a number of settings for this filter? Can I create a dropdown list where I already have john, jack, amy, and ann as options? The same problem pertains to several other columns that contain discrete values. Thanks, Edwin |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com