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

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

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

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