I have a workbook with multiple sheets, what I am trying to do is fill in
certain cells with rates when a particular craft is selected from a drop down box.
Example:
If Boilermaker is selected in drop down box in G2 located on "Timesheet" the it would populate the ST Rate in I2 of "Timesheet" & OT Rate K2 "Timesheet" & DTRate M2 "Timesheet" etc...
The Rates are located in another worksheet "Labor Rates" and are assigned by Craft, so lets say Boilermaker is located in "Labor Rates" A2, then the ST Rate is in "Labor Rates" C2, OTRate is in "Labor Rates" D2.
Is there a vba that will perform this function ?
I would like to stay away from large IF statements if possible.
Thanks in advance.. this is a great place..