I am stuck. I don't know if there is a function or a macro to help with my situation. I need to do this for thousands of row. Ex. I have 100 employee that all work different amount of hours.. I then have a bonus fund that needs to be allocated based on the percentage of hours works to total hours. However each bonus has to be equal or over a specific value (a predetermined cell aka X). My columns are as follow: (A) Employee, (B)Hours worked, (C) bonus amount (=B/Total Hours*total Bonus). I need to take these columns and turn them into a new report for these employees where the minimum bonus is X and all non allocated bonus is reallocated to remaining employees. The manual process is to copy these columns and formulas and then remove each row starting from the lowest amount under X. Each time one row is removed the other amounts above adjust and I keep repeating this until the lowest bonus is equal to or greater than X. Is there a way to do this in one sweep if I determine what X should be? and if they rerun using different values for X? THANK YOU