View Single Post
 
Old 10-22-2007, 07:40 PM
Grapejuice Grapejuice is offline
Novice
 
Join Date: Jun 2006
Location: Toronto Ontario Canada
Posts: 5
Grapejuice
Default Drop down box in a cell

I'm trying to find a way to make a cell into a drop down box with 5 to 8 selections. Depending on what is selected I would like to have 3 to 4 of the cells next to the drop down cell fill in some standard information based on the selections.
Eg. If "Reg Hours" is selected then to the right of it would fill in automaticaly a formula based on Regular hours so that all I have to do is type in the ammount of hours and excel will do the rest.
Reply With Quote