Ключевые слова: vba sort, vba sort excel, vba macro sort, excel macro sort, vba sort object, vba list build, vba short list, excel sort object, excel list build, excel short list, vba data mining, excel data mining, excel unstructured data, sort regular expressions

Unclutter Your Spreadsheets But Keep On Sorting!

Many people use Excel as their tool of choice and happily bend over backwards to get the job done. However, Excel's sorter is too limited for the things people use spreadsheets for, forcing them to make their data fit the sorter.

This leads to clutter on the sheets and all sorts of hazards creep in. Spreadsheets become hard to understand and difficult to maintain. Chances are that only the developer of the sheet knows how to use it.

LAselect, however, moves the sorting solution out of harm's way to a macro. It's internals can be tailored to any kind of data. Code is kept at a central location and does not have to be duplicated for reuse, lowering maintenance cost and time.

Standard sorters only handle simple data but an estimated 80% of information does not qualify as simple. We need a new approach and that is the LAselect FrameWork, a fast programmable list generator. Its separate input/output stages allow the user to freely interpret and reproduce the information. LAselect's interface does not require in-depth knowledge of Visual Basic.

LAselect sorts alphabetically, numerically, weighted, complex, fuzzy, etc. Regular Expressions sort embedded strings like postal or product codes.

Some examples of what LAselect would do:

o Conventional sorting without Excel's limitations
o Sort VBA arrays
o Create sorted Shortlists, Target-Lists, Reports
o Sort using Regular Expressions
o Sort IP-numbers or Chemical Nomenclature
o Sort on implied or weighted values
o Data-Mining

LAselect differs much from conventional sorting. Take the time to see what this engine can do for you or you'll miss out on chances to increase your productivity!