Hi All,

I've been tasked by my MD to create a simple (relatively) to use sheet that can easily calculate true stock quantity and as such current value of stock holdings.

We have systems in place to check the value of finished stock, but not work in progress. This is to ensure we have a faster solution than manually writing this down every time to calculate year end (End of March)

I've attached a sheet below with the base information

Sheet 1 will be the form my MD uses to add up stock value.
Sheet 2 has information for validation of drop down boxes & base codes
Sheet 3 has pallet quantities and cost per unit (To be set properly once we have the formulas correct)
Sheet 4 will be every conceivable combination of coatings, however I cannot progress until I know how to validate the prior information.


Here is my question to start:

Is there a way to filter the drop down Menu's, so that if I was to Select "Saucepan", the next selections I can make are only ever valid?

Please see the attached for reference.

Attachment 379023