List based Fault finding guide

[rodgerdooter]

hello all

im trying to create a fault finding guide that a large team of engineers can use to find problems on certain line with certain faults
currently we have all these guides in 100s of word documents

what i would like to be able to do is have all the machines , machine parts , faults , causes and solutions documented on excel
on a front page the user will have 5 or 6 boxes to populate ( using a list or drop down ) based on what line , machine and fault they are seeing , with each box showing the independant selections they are able to select next ( id like this because once the sheet is populated each box will have 100s of different selectiosn available )

on the spread sheet i have attached , in the FAULTS tba you will see all my line numbers , machines faults , causes etc etc - this will be populated with all my info
in the guide tab i would like the op to first select his line , then the list in the next tab will only have the machines available for the line he selected in the first row . this will then do the same all the way across


im not sure if something like this is possible , or maybe if there is an easier way of doing it ( which i am open too )

any help would be much appreciated :-)

[torachan]

One done a month or two back, probably slightly more complex than what you are asking for.
This app. was lacking as it was lacking an inputting form to collect initial data.
However the cascading comboboxes illustrate the filtering nature you require to analyse fault finding

follow the link to see the progress of the OP request

https://www.excelforum.com/excel-pro...ml#post5302855

Attached file to demo process. I will try over the next couple of days to put together something based upon your file

torachan.

[torachan]

The attached is the type of UserForm approach that I would suggest.
The coding is fairly simple to follow and edit if needed.
To enter new data first press 'Clear' this ensures the 'Add' button is activated, this is then disabled after saving so no duplicates
The rest should be intuative, the 'Fault Guide' page is a set of cascading comboboxes, starting at the top, then filter as you progress down.
torachan.

[rodgerdooter]

Oh my God
thanks so much this is absolutely perfect for what we need

i will have a play around with it this afternoon , mondays are not a good day

once again thanks for this