Hi
I have attached excel with leave data with input and output
In the sheet i have three types of Leave which is CL, SL & PL
If the employee availed leave more than the Opening balance then the leave should be adjust with the next column.
For example in the first data Mr. John has CL leave balance of 3 but he availed CL Leave 5. So his Leave balance showing in negative. In this scenario if he has leave in SL the same has been adjusted. If he did not have Leave balance in SL then the same will be adjust in PL Leave Balance. If the person did not have PL then the same will added in LOP column.
I need macro for this process currently i gave only four sample data. If i add more employees the same adjustment will be do in macro using for loop
Thanks
I have attached excel with leave data with input and output
In the sheet i have three types of Leave which is CL, SL & PL
If the employee availed leave more than the Opening balance then the leave should be adjust with the next column.
For example in the first data Mr. John has CL leave balance of 3 but he availed CL Leave 5. So his Leave balance showing in negative. In this scenario if he has leave in SL the same has been adjusted. If he did not have Leave balance in SL then the same will be adjust in PL Leave Balance. If the person did not have PL then the same will added in LOP column.
I need macro for this process currently i gave only four sample data. If i add more employees the same adjustment will be do in macro using for loop
Thanks