Okay guys, I think I've figured out the problem. The macro is working fine, but the reason it wasn't sorting the new additions (and still isn't) is because it only sets the range to whatever it was when I record the macro. As soon as I add in new orders, the range changes and the macro doesn't sort them all.
Pic attached is what I mean. If I set the macro while I've got Example 1 to 15, then add in 16 later, it'll only sort 1 to 15 upon opening. Any ideas, guys?
|