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