change cell values based on drop down box selection
 

I want to have a drop down box in excel. Based on the values selected in the
drop down box the values in the other cells in that row ( next to the drop
down ) should change. Is it possible using macros? or anything else?