Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to update cells with Data validation in them?
All,
I have the following problem: I want to I change the data from the Data Validation:List:Source and this change to be reflected in the corresponding cells. How can I do this? I understand some macro programming but not much... Example: My source are C2:F2 containing 50, 90, 110 and 150. My target cells are G6:G8 containing 50, 50, 110, 150 (entered from a dropdown data validation list). If I change C2 to be 30, I want G6 and G7 to become 30 also. I hope I am being clear :) Thanks in advance, Bojana |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to update cells with Data validation in them?
Is there a reason you just don't use a formula in those other cells (G6:G8).
=c2 =d2 =f2 (I'm not sure how 4 cells correspond to 3 cells, though.) If you really were asking about how to change the validation list based on the value in another cell, you may want to look at how Debra Dalgleish did it: http://www.contextures.com/xlDataVal02.html Bojana wrote: All, I have the following problem: I want to I change the data from the Data Validation:List:Source and this change to be reflected in the corresponding cells. How can I do this? I understand some macro programming but not much... Example: My source are C2:F2 containing 50, 90, 110 and 150. My target cells are G6:G8 containing 50, 50, 110, 150 (entered from a dropdown data validation list). If I change C2 to be 30, I want G6 and G7 to become 30 also. I hope I am being clear :) Thanks in advance, Bojana -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to update cells with Data validation in them?
I cannot use them directly because I am calculating with their
time-discounted values and teh cells in G column are my "user interface". Debra's article does not solve my problem. I was asking how to update the values put in cells via Data validation mechanisme if the source for data validation has been changed. "Dave Peterson" wrote: Is there a reason you just don't use a formula in those other cells (G6:G8). =c2 =d2 =f2 (I'm not sure how 4 cells correspond to 3 cells, though.) If you really were asking about how to change the validation list based on the value in another cell, you may want to look at how Debra Dalgleish did it: http://www.contextures.com/xlDataVal02.html Bojana wrote: All, I have the following problem: I want to I change the data from the Data Validation:List:Source and this change to be reflected in the corresponding cells. How can I do this? I understand some macro programming but not much... Example: My source are C2:F2 containing 50, 90, 110 and 150. My target cells are G6:G8 containing 50, 50, 110, 150 (entered from a dropdown data validation list). If I change C2 to be 30, I want G6 and G7 to become 30 also. I hope I am being clear :) Thanks in advance, Bojana -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to update cells with Data validation in them?
I think you'll have to post more of the rules you need to use.
When you do, I'm sure someone will jump in with a suggestion. Bojana wrote: I cannot use them directly because I am calculating with their time-discounted values and teh cells in G column are my "user interface". Debra's article does not solve my problem. I was asking how to update the values put in cells via Data validation mechanisme if the source for data validation has been changed. "Dave Peterson" wrote: Is there a reason you just don't use a formula in those other cells (G6:G8). =c2 =d2 =f2 (I'm not sure how 4 cells correspond to 3 cells, though.) If you really were asking about how to change the validation list based on the value in another cell, you may want to look at how Debra Dalgleish did it: http://www.contextures.com/xlDataVal02.html Bojana wrote: All, I have the following problem: I want to I change the data from the Data Validation:List:Source and this change to be reflected in the corresponding cells. How can I do this? I understand some macro programming but not much... Example: My source are C2:F2 containing 50, 90, 110 and 150. My target cells are G6:G8 containing 50, 50, 110, 150 (entered from a dropdown data validation list). If I change C2 to be 30, I want G6 and G7 to become 30 also. I hope I am being clear :) Thanks in advance, Bojana -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Data validation named range update | Excel Discussion (Misc queries) |