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