I have created several Advanced Filters in a large spreadsheet and I would like to have the filters added to the “Read Filter Criteria From” list shown in image below. For example, I would like “filter1, filter2, …” added to the list. Currently, the list displays only “Undefined” and I cannot find a means of adding new items to the list. Thanks!
Assign a criteria cell range a name (Sheet → Named Ranges and Expressions → Define (or Manage, or Ctrl+F3)) and there under Range Options activate Filter for that range.
Thank you - works great!!! I never would have figured this out 
Glad to help. Then please mark the answer as correct by clicking the check mark icon.