Autofilter based on sequential table values

[swanseaexcel]

Hi all,

I'm trying to design a macro that will allow a user to enter a specification they are looking for and based on that specification a macro autofilters a table of data and returns suitable results.

In my basic example attached it shows 10 rows of an example stock list where the length and the gauge of the stock is shown.

If the user entered, for example a requirement of 900 length and 12B gauge then I want the autofilter to apply the following rules:

1) The length can be -3mm or any larger size than specified
2) The gauge can be -1 or +1 entry on the gauge table shown on the right hand side

All help appreciated!

Thanks.

[swanseaexcel]

Can anyone help with this?

Or do I need to clarify any areas of the question a bit more?