List box values

[ootsoo]

hi all,

need a small help in excel.

i add a data to a cell using list box.

suppose the datas in the drop down list of cell A2 are say 100,200.

now suppose 100 is chosed using the drop down list a set of values are to updated in the cells B5 to B10.

but if 200 is chosen using the drop down list a different set of values are to updated in the cells B5 to B10.

how is that to be done?

Plz do give me some tips.

regards,

Ootsoo