Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create two Data validation lists that are linked(Both change toget
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create two Data validation lists that are linked(Both change toget
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 "VChaseS" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create two Data validation lists that are linked(Both change toget
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel -- Data Validation -- Create Dependent Lists | Excel Worksheet Functions | |||
Linked Lists / Data Validation - Excel 97 | Excel Worksheet Functions | |||
How to create Dropdown lists not using Data Validation | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Data Validation - Create dependent lists | Excel Discussion (Misc queries) |