Auto Filter

Hi Fam, Thanks for the post, welcome to the forum, in answer to your question, Auto Filter only works on columns, when we set Custom Filters we can use AND and OR to extract from different columns using those criteria, even when we use Advanced Filter we are extracting complex criteria but still only from columns. the reason behind this is that we always set up our databases in the same way, with field headings along the first row, and under each heading (down the column) the data relating to the heading.
Therefore each row becomes a single record.
I hope that answers your question, if so please click the resolved link, best regards Pete.