I need assistance :
I have three sheets:
Workday sheet -with all basic employees info
Payment sheet- to show payments (salary payments - current i.e new financial year)
Revised Salary Sheet
I want to achieve these points as i am unable to have form a group by employee number and fufill first point.
(also **all workday employees is present in payment sheet and vice versa)
A) From workday sheet i have to calculate monthly payments per employee as it has annual pay and compare it against payment sheet (whether correct amount is paid or not month wise)
if there is a change consider sheet Revised salary sheet having old and new both annual salary and then check if there is exception)
< monthly payment is diff for each country i.e India= annual pay/12 , australia: annual/12 , usa: annual pay/14 )
B) bonus amount is paid just once.
c) joining date matches in workday sheet and payment sheet.
Thank you in advance to everyone who will contribute to help me in this.
