A macro enabled Drop down list

[sanspeed]

Hi

I need help in excel w.r.t a Macro enabled drop down list that both represents a particular column of a sheet and also populates various other columns of another sheet (all are w.r.t one single WB). I Already have gone through basics of macros, and I am aware about the working of it. I just need to have a code (Outline/ blueprint) that enables me to add my customized rows and columns to it.

Thanks in advance.

-san