Hi,

I need to be able to select an item from a drop down list and then for my selection to then populate several cells with pre determined information from another sheet.

For Example...

If I Select the 'Vanilla' option of ice cream from a drop down list on Sheet 2. I need it to look at Sheet 1, Row 6 and copy Cells A6, B6, C6 & D6.

Then populate Sheet 2, Row 2 with the copied info.



I'm a novice to excel so if this is possible can you please explain a simple as possible.

Thanks loads for any help you can provide.

If you need more info from me, then just let me know.

Cheers

Phibir