Payroll employee exit query

[akashsadhu]

i am preparing payroll sheet. there is mastersheet where all employee data available and there are 12 sheets for attendance and salary. if any employee leave the job his data wont be showup in further month in aatendace and salary sheets but his past month data must be there for records..

how can i perform this?

 

[t0ny84]

i am preparing payroll sheet. there is mastersheet where all employee data available and there are 12 sheets for attendance and salary. if any employee leave the job his data wont be showup in further month in aatendace and salary sheets but his past month data must be there for records..

how can i perform this?

Are you building this from scratch or do you have one already that you are modifying?
If you do not have one already you could use a template (examples below) and modify it to suit your specific workplace.

Payroll Template for Excel

Download a free Excel Payroll Register template to help you record and track your employee payroll information, payroll payments, and hours worked.

www.vertex42.com

Free templates for social media, documents & designs | Microsoft Create

Use our free tools and customizable templates to craft presentations, videos, graphics, social media designs, and much more—no design expertise required.

templates.office.com

Business-related design templates | Microsoft Create

Work with customizable design templates for business assets. From print projects to digital designs for business assets, find everything you need for boosting business visibility.

templates.office.com

t0ny84

 

[akashsadhu]

We almost created / modified as our need , we also gone through that readymade sheets but there is nothing what we are looking for..
so i landed here to fulfill my requirements