It would be helpful to see a sample workbook so we can work out what it is you are trying to achieve. My intention was that you use the advanced filter on your original list to restrict the data you are viewing.
The criteria range is a range (at least two rows) with the first row having headers that match your list headers. If you want the filtering to happen automatically as you type, you can use code to achieve that, but again, we'd need more detail.
Bookmarks