Im trying to create a custom userform based off of data in a sheet. The way
the worksheet is layed out is as follows

Tag Name EngineType Shaft Combustion FuelType Etc.
Option1 e1,e2 only ALL C L
Option2 e1,e4,e5 CED S G
Option3 ALL HED S Dual

So basically this sheet tells you what "Tag Name" to use as a label on the
userform. This is achieved based on your criteria. So if I only want to see
all the e1/S options then this will tell me to use Opton2 & Option3.

Now, Question is what is the best way to select the appropriate Tag Name
based off of my criteria. I was thinking about using arrays but not too
familiar with them and havent used them in VBA. Im currently doing a series
of autofilters and working with the Visiblecells. Any feedback would be very
helpful. Thanks in advance