http://rapidshare.com/files/1633017282/Dynamic%20Quality%20Assurance%20Invoice.xlsx
On Equipment after selecting Description, I want it to auto populate UNIT (B) & RATE (K)
On Labor after selecting Employee I want it to auto populate PERDIEM (G), RATE (I) & O/T RATE (K). THANK YOU!
I need to auto populate 3 vertical cells after selecting Employee's name from EMPLOYEE SHEET drop down. Perdiem, Rate, O/T Rate also come from EMPLOYEE SHEET.
Merged Cells Enter Auto Enter Auto Enter Auto Calculated
Drop Down
D & E F G H I...
I have figured out the Data Validation for several drop down menus, but can't get a handle on IF and VLOOKUP, so I can get data to auto populate after selecting an employee. Saw you on google and thought I'd see what you have to offer. I need help, but not sure how I get it and what I should or...