I have a spreadsheet - data range A8:AO500 (headers in A8-AO8) and I would like to use cells B7 and B8 as cells that can be typed in and then the data below will autofilter for rows which contain the critiera typed in the cell (same column). There is a solution on this thread, however, it is only for a text box. I need the exact same results, however, would like to type into a cell rather than a text box.
http://www.excelforum.com/excel-gene...html?p=2815698