Thread: Using a drop down box to activate a formula

Hi,

I have a stock sheet that uses a stock movement sheet for incoming and out going stock - the stock is broken down into 2 categories OPEX stock and CAPEX stock - until recently I have used 2 sets of each column under each heading to list stock movement - Opex Stock Issued & Opex Stock Deliveries and Capex Stock Issued & Capex Stock Deliveries.

The 2 problems I am trying to overcome are -

I need capex stock to be used before opex stock is touched (so a calculation for when it reaches 0 to activate the opex stock usage) and I need opex and capex delivered stock to be designated to the correct columns after the correct item in the luist has been selected.