Setting up data validation and lookup tables...?

[Birmangirl]

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

 

[Dave Peterson]

Maybe you could use Data|Validation and use dependent lists.

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

 

[Birmangirl]

Thanks for the suggestion Dave - I have seen Debra's article, but just
couldn't quite get it to work. Operator failure, I fear! I'll take another
look and give it a go.

Cheers, Amanda

 

[Dave Peterson]

There's a sample file that you can download and experiment with.