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...