You have to assign a macro to the Summary dropdown. Something like this:

Sub DropDown1_Change()
Dim NewVal As Integer
NewVal = Worksheets("Summary").Range("A1").Value
Worksheets("Sub1").Range("A1").Value = NewVal
Worksheets("Sub2").Range("A1").Value = NewVal
''Etc.
End Sub


--
Jim
"Boon8888" wrote in
message ...
|
| 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
|