On Mon, 25 Jan 2010 08:30:01 -0800, VChaseS
wrote:

Hi,

I would like to create two or more validation lists of the same range of
data. Currently, I have a number of graphs on different worksheets that can
be updated by choosing from a drop down list (data validation list).
Basically, that list is referenced in a lookup function which gathers
information into a range that then updates the graphs. Right now, I have to
click back and forth between many sheets in order to to change the drop down
menu. It would be ideal that if each worksheet with a graph had the exact
same drop down menu that when updated, updates each of the other drop down
menus accordingly. So if I change the list in worksheet 1, all worksheets
lists update. If I change the list in worksheet 2, all of the worksheets
lists update...and so on.

I have the same problem with just single cells. I need to have two or more
cells act exactly the same. For example, I have cells A1 and B1. If I change
A1 to yellow, B1 should change to yellow. Then, if I change B1 to Red, A1
should change to red. As you can see, I need to be able to change both cells
(for convenience to the user) as if they were both linked to an underlying
cell except without having to find and click on the underlying cell to change
A1 and B1, I want to just click on either A1 and B1 to change it. Does this
make sense?



See if the pop up boxes on this perpetual calendar's set-up page works
the way you want. There are hidden columns that have data in them that
the pop up boxes get referred to in the non-hidden area.