data changes

**aquinlan** · 05-01-2010, 05:11 AM

Hello there,
Is this possible through excel or vba.Please see attached and sheet2 for explanation.thank you.

**royUK** · 05-01-2010, 05:13 AM

You will get more response if you outline the problem in the actual post. Not everyone can or will download the example,especially to see what the problem is.

Also,your thread title should indicate the problem

**aquinlan** · 05-01-2010, 05:40 AM

ok roy,
In the dummy wb in Col A(sheet1) from a2 to a9 i have dropdown boxs with names.each name corresponds to there own column which holds there individual data.On sheet2,3 i have in colA the same dropdowns. So if in sheet1 i pick a name from dropdown i would like the matching cell in Col B to pick one number randomly from that names own column which holds there individual data.And for sheet2,3 will be the same they will pick from sheet1.for ei sheet1 colA (a2) i pick peter then b2 will randomly choose from n2:n10 but if i change then (a2) to alan b2 will now pick from i2:i10.And with sheet2 (a2) i pick peter it will choose randomly from sheet1(n2:n10).If anyone can help it would be great.any suggestions would be great too.Thank you.

**teylyn** · 05-01-2010, 05:53 AM

try this

=INDEX(Sheet1!$H$2:$O$10,RANDBETWEEN(1,9),MATCH(Sheet2!A2,Sheet1!$H$1:$O$1,0))

although it will recalculate any time you change any cell in the sheet. But it will look only for the name in colum A of the respective row and select one of the values for that person.