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.