linked drop down lists

[Priglett]

please help, I want to write a list of items in one cell which when the item
is selected will place a value linked to that item in another cell which in
turn will do the same to another cell. Any ideas?
Thanx in advance

 

[Paul B]

Priglett, have a look here,

http://www.contextures.com/xlDataVal02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Priglett]

Brilliant site . Thanx
Now just have to learn it all