I have been working to make some drop down list but I have been unsuccessful
so far. I figured I would let you all know what I am trying to do and see if
I am approaching this the wrong way.
What I want is to have a Excel workbook for Quotes. In this workbook I want
to have a drop down list that will allow someone to pick a type of equipment.
Then I want a second drop down list that will be varied based on what was
picked in the first drop down list. Finally I want a price place in a third
box based on the second drop down list. Sounds easy enough but here is the
twist and the hard part. The drop down list source needs to be external
because there are many changes that happen to it regularly so we need to be
able to go to one central location and change a price or add a entry to the
list so it will affect the quotes when they are opened rather than having to
change each quote individually which would be virtually impossible.

Thanks for any help and feel free to ask any question that I can answer to
help define the problem.

Wayne Drummond