I have a 12,000 row financial data set that has details of financial transactions in each row (i.e. 12,000 financial transactions on 12,000 rows) and is sorted by cost centre and am wanting functionality that allows only the transactions of one cost centre to show at a time when a user inputs their cost centre number to cell. Ideally the cell input would be on a separate worksheet. I am aware of autofilter however this requires the user to select from the drop down list and I am looking to automate this process as much as possible to achieve user acceptance.

I have come across Advanced Filter which seems to do the job but the "Unique Records Only" tick box does not stay selected after each input of a cost centre and has to be re-selected before each cell input.