Hi,
I have the below table and i need a macro to sort by specific words in column "D", words that are part of a group, then to add the name of the group in column B. And after each group to make a total for that group's value and qty.
The table starts from A5.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is how i need the table to be:
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I need to make groups inside the macro with products that will be part of that group. The words could be at the begining or as part of the product name.
Also, it would be great to put all unidentified products to an "Unknown" group at the end of all sorted groups.
Can this be done?
Thank you in advance,
Apollo.
I have the below table and i need a macro to sort by specific words in column "D", words that are part of a group, then to add the name of the group in column B. And after each group to make a total for that group's value and qty.
The table starts from A5.
Supplier | Group | Cod | Description | Value | Qty |
supplier 1 | s 228 | scissor 1 | 3,781.19 | 1,614.00 | |
supplier 2 | t 141 | tweezer 82 | 2,187.25 | 1,958.00 | |
supplier 2 | t 222 | tweezer 101 | 5,515.33 | 4,184.00 | |
supplier 1 | s 259 | scissor 89 | 8,214.13 | 3,435.00 | |
supplier 1 | s 235 | cuticle scissor 33 | 1,989.64 | 775.00 | |
supplier 2 | t389 | oblique tweezer 16 | 2,989.12 | 1,312.00 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is how i need the table to be:
Supplier | Group | Cod | Description | Value | Qty |
supplier 1 | scissor | s 228 | scissor 1 | 3,781.19 | 1,614.00 |
supplier 1 | scissor | s 259 | scissor 89 | 8,214.13 | 3,435.00 |
supplier 1 | scissor | s 235 | cuticle scissor 33 | 1,989.64 | 775.00 |
scissor total | 13,984.96 | 5,824.00 | |||
supplier 2 | tweezer | t 141 | tweezer 82 | 2,187.25 | 1,958.00 |
supplier 2 | tweezer | t 222 | tweezer 101 | 5,515.33 | 4,184.00 |
supplier 2 | tweezer | t389 | oblique tweezer 16 | 2,989.12 | 1,312.00 |
tweezer total | 10,691.70 | 7,454.00 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I need to make groups inside the macro with products that will be part of that group. The words could be at the begining or as part of the product name.
Also, it would be great to put all unidentified products to an "Unknown" group at the end of all sorted groups.
Can this be done?
Thank you in advance,
Apollo.