I am trying to create a macro for a small business to help with their payroll. It would be simply the user typing in the name and the hours worked. The other cells would have formulas to help calculate the net pay. The table below shows an example of what I am doing right now. On one tab, I have the names of the employees and their pay rates. On the other tab, I manually enter the employee names and the ones in green have formulas. I would highlight the columns starting from pay rate to net pay and drag down the formulas to help me with the total deductions and net pay. How can I go about doing on vba userform? Or is there another better way to do this. Once I have a quarter worth of payroll entries, I would like to turn them into visual data.
Employee | Pay Rate |
Joe | $ 8.75 |
Bill | $ 10.50 |
Tom | $ 12.00 |
Andy | $ 8.75 |
Tony | $ 8.75 |
Jenny | $ 8.75 |
Allah | $ 12.75 |
Date | Employee | Pay Rate | Regular Hours Worked | Overtime Hours | Gross | FICA | Med | W/H | Credit | Advance Payment | Total Deductions | Net Pay |
Tony | $ 8.75 | 80 | 15 | $ 896.88 | $ 55.61 | $ 13.00 | $ 68.61 | $ 828.26 | ||||
Bill | $ 10.50 | 80 | 15 | $ 1,076.25 | $ 66.73 | $ 15.61 | $ 100.00 | $ 182.33 | $ 893.92 |