Creating a user interface for an excel file.

hello all,

I have been tasked by the company I work for to come up with a simple to use interface that can be used by someone with little understanding of excel to set the autofilters to certain settings.

So here is what I have:

2 sheets (each with the same number of columns but different data which corresponds to good and no-good)

Each column has an autofilter but only two on each sheet need to be set.

One filter controls valve type (of which there are 10) and the other controls running condition (startup and normal)

Now my employer wants something that is basically idiot proof so that someone can simply open up the excel file, input the valve type and running condition, and be rewarded with only the corresponding data and charts. Now the filters are already in place, the charts already exist and the only thing left is the user interface.

Anyone got any ideas? Help would be much appreciated.
Note, I don't have any understanding of VBA but I do know a bit of FORTRAN if that helps.

Sean H