View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default how to create new records of staff payroll

Hi,

This question is not clear, what exactly do you want? You could:

Take a copy of the old workbook and remove all the old data but keep all the
formulas, formatting and structure.

--
Thanks,
Shane Devenshire


"use the name" wrote:

new staff payroll as at 31st jan 2008.
1.staff name
2.staff department
3.i.d
4.sex
5.transport,medical,housing,feeding allowance
you have to calculate no.5 through no.8 to get the total paid of each staff
are varies.
you have to subtract the salary of each staff from the gross paid to get the
net paid of each staff.