Is there anyway to create VBA that will tell Excel that 528 > 670 ? I want contracts numbered 528X-1111 and 528X-1112 to be listed before contracts numbered 670-1110 and 670-1109 but it doesn't want to when I sort by descending number. Is there a way to fool Excel into thinking that 528 is greater? Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Fooling Excel
- Thread starter Tonto111
- Start date
Similar threads
