I have a worksheet that has 500 or 600 line items in it...

I also have in a different worksheet some customer information.

I would like to be able to click on a button (or some other method of invoking) and have Excel perform a data filter on the 500 row spreadsheet for a specific customer number which is a column in the spreadsheet.

IE... Click on the button and it goes to the line item worksheet and it is only showing the items pertinent to that customer. (Similar to what Data Filter's do.)

Programatically (via the button) I want to invoke the filter.