Hi, basically I have one sheet in my workbook, that contains summary information and is called 'Summary'. It has one dropdownlist in it. I would like it to be set up so that if I change the value in my dropdownlist in my Summary worksheet, that the dropdownlists in my other sheets also change to this value. But at the same time, the other dropdownlists should be able to take on a value of their own, and only change to the value contained in the Summary sheet if it is changed.

I hope this makes sense.

I have tried just having the formula in my other dropdownlists:

=Summary!E1

where E1 is the cell containing the dropdownlist

This works, but as soon as I change the value in those dropdownlists independently to something else, that formula is lost.

Any ideas, suggestions or help is greatly appreciated. Thanks,

Joel