I have a macro that shows contracts of a certain type (supply, construction, etc.) It then sorts the contracts in order, with the highest number (most recent contract) on top.
However, we recently changed the prefix for our contracts from 670X to 528X, but kept the sequential numbers at the end. For example, an old contract would be 670X-100, while the next contract under the new system would be 528X-101. When you try to sort by descending order, it wants to put these new contracts at the bottom because 528 is less than 670. Any ways to get around this? THANKS
However, we recently changed the prefix for our contracts from 670X to 528X, but kept the sequential numbers at the end. For example, an old contract would be 670X-100, while the next contract under the new system would be 528X-101. When you try to sort by descending order, it wants to put these new contracts at the bottom because 528 is less than 670. Any ways to get around this? THANKS