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


--
Boon8888
------------------------------------------------------------------------
Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647
View this thread: http://www.excelforum.com/showthread...hreadid=511840