Hi,

I am new to MS Excel.

I have a requirement to display a list of values in a cell say B3 in Sheet1. Based on the value the user selects among the list, I have to populate the data available between a particular range from Sheet2.

For example, if the item1 is selected in B3 of Sheet1, I have to populate the values available between C3 and H3 from Sheet2 into C3:H3 in Sheet1. If the item2 is selected in B3 of Sheet1, I have to populate the values available in C4:H4 and similiary for item3 and item4.

Please help me in implementing this.

Thanks & Regards
Yuvi