Macro - sorting by a specific word

[ApolloID]

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.

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.

 

[VoG]

Duplicate http://www.mrexcel.com/forum/excel-questions/813518-macro-sorting-specific-word.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).