• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Leave balance adjustment


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