I need a macro to find the last record used (A47), Insert a new row for an new Emp,
Copy the formula from the previous row (c46-J46) down to the next row(A47).
Go to cell (A47) so new Emp can be entered.
When I delete an Emp, change total formula for existing emp only.