Create two Data validation lists that are linked(Both change toget

[VChaseS]

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?

 

[Otto Moehrbach]

Regarding the Data Validation cells. Create one list somewhere. Name that
range something, say, MyList. Setup every Data Validation cell to List and
type "=MyList", without the quotes, in the "Source" line. When you want to
change the list, go to the list. Change it. If the range is changed
because you added or deleted an item, name the new range "MyList". Done.
The other thing. I know of no way to link cell formats. Perhaps you can
link the situation that caused the user to want to change the color of some
cell. Then Conditional Formatting or VBA can be used to change the color of
both cells. HTH Otto

 

[Capt. Cave Man]

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.