There are a few ways this can be done but it is difficult to give one of the options without seeing a sample sheet. If you are using the Auto-Filter currently can you just type the customer name in the search box that comes up when you click on the filter arrow and then select your customer? If that wont work then I can write something where you click on a button and then inputbox will come up asking for the name. You type in the name and then the filter will give you the results it finds. This however does not always work because you may have more than 1 customer named John etc. Posting a sample sheet with the desired result will allow me to get a better idea on what solution to provide.

Thanks