I am trying to create a pull down menu which can populate 2 other separate
cells of information in a given row which are linked to the data in the
pulldown menu. When I select a choice from the pull down menu. The pull down
menu will have about 30 selections. I want some text which I somehow link to
the data in the pull down menu to show up in a predetermined cell in the same
row as the pull down menu.

The data will be in worksheet 1 and the the pulldown menus will be in a
separate worksheet. The purpose of this is to create a Quote request form
which allows me to pick descriptions of products that will automatically
populate the part numbers and prices. There are about 30 separate pat
numbers . The quote sheet sheet will also need to have the samepull dlwon
menus in multiple rows to allow for quoting of multiple items
thanks

The key quesitons here are