xlFilterCopy with multiple criteria

[swanseaexcel]

Afternoon all,

I have a macro I use below to filter a set of data and paste it into a new sheet:

Please Login or Register  to view this content.

In the "stock analysis" tab, Cell A1 is the heading "Customer Name" and A2 is a blank field where the user can input the customer name. Clicking a button I've attached will filter the full list in "Latest stock" and paste the entries for the specified customer into "Stock Analysis".

I want to add another criteria where in addition to the customer name, the user can enter an "Age From" and "Age To." In the Latest stock list there is a column of data where the age of the stock (in days) is posted. In the "Stock analysis" tab I plan B1:B2 to be age from and C1:C2 to be age to.

Can anyone help?

Many thanks!