HI all

first time postin ghere so apolosies if its wrong or badly explained.

I have a single controlling cell , this cell is a list cell and controls 4 other cells , by changing the value in the controling cell it cahnges the availble lists i can select from in the other 4 cells , this is working really well. My challenge however is that if the controlling cell changes it does not reset the other cells to 0 soi can start my selcections again.

Sorry if it does not read well

Kind regards

Pete