Sync two drop down lists

Giganews Newsgroups
Subject: Sync two drop down lists
Posted by:  Mac (josip.20…
Date: Fri, 14 Jan 2011


could somebody please help me out with this problem.
Let's say that I have two sheets and an identical drop box list on
both of these sheets. That is, both drop boxes give the user the same/
identical choices of selectable alternatives. I want these boxes to be
in sync: if the user selects "apples" on one sheet... the drop box on
the other sheet should automatically change to "apples" as well. As
the user may initialize the change on any of the two sheets, the sync
needs to work both ways (always updating according to the latest

Can this be done using list drop-boxes? I do not want to use combo-