Hi,
I'm sure similar payroll questions have been answered – I just can't find one to suit. I'm trying to help a friend by setting up a payslip / payroll tracker with excel. I have the payslips, and we'll use them to enter data on a weekly basis from the field. I just need to work out how to pull the data from each weeks work into a running total
<tbody>
</tbody>
I have 40 tables similar to the above per week (per sheet), one for each employee. The season goes for 12 weeks so I have 12 tabs/sheets along the bottom. The above sheets double as a printable payslip.
I want to be able to pull data from each table and each sheet into one sheet that captures a running total of 'Super', 'Tax' and 'Nett' amounts as we go. I can go through and manually input ='sheet2'!F58 but I feel like there must be a better way.
Any ideas, or pointers would be much appreciated!
Thanks
I'm sure similar payroll questions have been answered – I just can't find one to suit. I'm trying to help a friend by setting up a payslip / payroll tracker with excel. I have the payslips, and we'll use them to enter data on a weekly basis from the field. I just need to work out how to pull the data from each weeks work into a running total
Day | Rate | Hrs | Total |
Mon | 30 | 38 | 1140 |
Tue | etc | ||
Etc | |||
Gross | 1140 | ||
Tax @ 13% | 148.20 | ||
Nett | 991.80 | ||
Super9.25% | 105.45 |
<tbody>
</tbody>
I have 40 tables similar to the above per week (per sheet), one for each employee. The season goes for 12 weeks so I have 12 tabs/sheets along the bottom. The above sheets double as a printable payslip.
I want to be able to pull data from each table and each sheet into one sheet that captures a running total of 'Super', 'Tax' and 'Nett' amounts as we go. I can go through and manually input ='sheet2'!F58 but I feel like there must be a better way.
Any ideas, or pointers would be much appreciated!
Thanks