I am assuming here but it appears that your code works fine. What may not work is when you change a value on the first sheet and then go to see the sort results. This will not change until something is changed in column K. However if you insert your same code on the worksheet activate sub it should work. When you say manually change the numbers I was confused because the numbers in column K are all formulas that if changed you would lose the formula.



Let me know if the worksheet activate fixes the issue.