I think that by using the debugging tool in the VBEditor you will be perfectly able to see what the code does and to improve it. Especially when applied to the workbook with real data (that we haven't been provided with).
Better than asking for a solution is acquiring the means, methods and ability to solve problems yourself.