Good afternoon,
I have a list of numbers that simply are not sorting correctly. I've used macros and VBA code I found to solve this issue with a different spreadsheet, but when I simply duplicated the sheet to use with a different set of numbers, the custom sort no longer works. I am not that savvy when it comes to VBA but highly motivated and willing to learn.
I've attached the file I am working with. Any help or guidance is appreciated.
Thanks so much!
What does "the custom sort no longer works." mean?
You have two worksheets, one visible, one hidden. But you have one CustomSortClickmacro that refers to the visible sheet and the Table on it ( Deed Doc#s (2) and Table22 ). You have a "button" on each sheet to call CustomSortClick but it will only work on Table22.
You don't really need a UDF to extract the numeric part of the code. You have a formula to extract the alphabetic part of the code ( =RIGHT(C3,5) ), so you can use that to get the numeric part:Probably a lot quicker and you don't have to have macros enabled for it to function.Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Revised Code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks