I need some assistance in getting some automation with some list boxes. We have multiple Craft employees, (App. Mech, Mech, App Elec, Elect, etc) and a different hourly dollar value for each of them. ($5, $10, $15 etc.) What I want to do is set a drop down box with the Craft employees, and then when the selection is made that it populates another cell with the dollar value that employee would cost..

I can then calculate the cost for the number of hours that employee will work.

Could anyone give me a little help on this one.

Thanks
Todd