Is it possible to use the value in cell A1 to filter the values in B1:B10? I am trying to use a user input to automatically set the auto filter rather than require the user to click the filter arrow and choose the filter value thay want. Thanks in advance.