Do the six cells require different lists? For example, does list 1 show
PartA for the selected manufacturer, and list 2 show PartB?

If so, how is the information stored in your workbook?

beel wrote:
In have been looking over Debra Dalgleish's info (great stuff there)
and the advanced newsgroups but can't seem to find an answer to my
problem.

I have one validation box with 6 manufacturers in it, there are then 6
other cells with data validation in which depend on the value chosen in
the first cell. i.e. (in short)

Maker aaa bbb ccc
aaa part a part a part b
bbb part b part g part f
ccc part f part h part h

Indirect only links to first, I think I need offset but cannot work it
out, (comes of being old I suppose). I'm sure I am missing something
straightforward.
Any help would be much appreciated
Regards
Bill



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html