I'm using Excel 2003. I need to create a spreadsheet to give to other users
so that they can record faults. I'm just not sure of the best way to do it,
so any help and advice would be gratefully accepted...
Initially, users need to choose between four basic fault types: Hydrostatic,
Engine, Transmission, and Cooler Group. Using one of these as an example, if
they choose Engine, I need them to only see two choices: Mechanical or
Electrical. If they choose Mechanical, they can only see the following: Fuel,
Turbo, Power Pack , Assembly, Heads, Camshaft, Oil.
I've listed just one path, but I'm sure you get the drift...

TIA, Amanda