Thanks Gord - Sound Brilliant

Gord Dibben wrote:
See Debra Dalgleish's site for dependent dropdowns.

http://www.contextures.on.ca/xlDataVal02.html

Debra shows how to make three dependent lists.

You can create as many as you wish.

On sheet2 simply enter linking formulas back to the 5 cells on sheet1.

Gord Dibben MS Excel MVP

Hi All,
I have a spreadsheet with the following columns of data
[quoted text clipped - 18 lines]
Many Thanks in advance for your replies
Matt

--
Matt Lynn

Message posted via http://www.officekb.com