VB code to Group by certain text in cells

[rizmomin]

Hello:

Please refer to attached file.
I need VB Code to filter column A so that all sizes (end of item Name) are grouped together

Let me know if you have any questions.
Thanks.

Riz

[mjr veverka]

Can not you use the auxiliary/helping column for these capacities, measures ?

[sintek]

Hi Riz

Perhaps this...Adapted from jindon's code...

Please Login or Register  to view this content.

[Leith Ross]

Hello Riz,

As with any sorting procedure, there are always some exceptions to the rules. Here are the three I found in your workbook: JIM BEAM LTR, JIM BEAM DISTILLER'S CUT 750, and JIM BEAM APPLE. The remaining data can be sorted in ascending order (case is ignored) like this: 50ml, 100ml, 200ml, 375ml, 750ml, 1000ml, 1L, 1.75L . A normal text sort will not produce these results, smallest to largest. To achieve a sort like this requires a Custom Sort list.

The attached workbook contains two macros. The first macro checks if the Custom Sort List exists and creates it if it does not exist and then returns the position of the new sort list in the Sort Lists used by Excel. The second macro removes the size information using Regular Expressions, places this in a helper column (the column on the right side the original list) and then sorts the data using the Custom Sort. There is a button on "Sheet1" to run the macros.

Please Login or Register  to view this content.

[sintek]

Perhaps this amended code could also work...Not sure what desired output should be...

Please Login or Register  to view this content.