Hi,

I am hoping to set up excel in order to help formulate a pricelist to help with tendering.

I am planning on setting up an internal pricelist in a folder which will be linked back to our pricing sheet and can be updated regularly.

I would like the first drop down list to include elements such as an over product type eg. pumps, tanks, actuators etc. This would then be followed up with another dropdown list which would be dependant on what is selected in the first ie. for pumps it would show centrifugal, submersible, dewatering and tanks would show concrete, glass lined and if actuators was selected the next list would show automatic, manual. This would then lead to another dropdown lists, and possible another until it can get to an actual model or product which would then relate to the pricelist and show the price.

I understand this is alot and may not actually be possible.

Thanks in advance.