How to automatically group changing data ?

[Ekmelnikov]

I work as a sales data analyst for a clothing manufacturer. And I often make sales reports that are structured by Brand-season-Category.

I constantly have to manually select rows and group data. Maybe there is a way to write a macro to do this automatically ?

A macro with constant strings will not work, since the number of categories for different brands may change from report to report, since the nomenclature and the review period change periodically.

I attach a picture of an example of how the data looks and how they should be grouped:

Книга12
	A	B	C
2	BRAND 1	SALES 46 WEEK	SALES 47 week
3	AW18-19	2	2
4	Trousers
5	Turtleneck
6	Leggings
7	Longsleeve
8	Pajamas (longsleeve, trousers)
9	Dress
10	Sliders
11	Sweatshirt
12	Sweatshirt (with collar)
13	Sweatshirt (with zipper)
14	T-shirt
15	Hoodies
16	AW19-20
17	Bomber	1	1
18	Trousers
19	Turtleneck
20	Cardigan
21	Leggings
22	Longsleeve
23	Nightgown
24	Dress
25	Sweatshirt	1
26	Slip
27	Top
28	Tunic
29	T-shirt
30	Polo Shirt		1
31	Shorts
32	BRAND 2	311	341
33	SS22	311	341
34	Suit (sweatshirt, trousers)	1	0
35	Suit (T-shirt, shorts)	0	4
36	Suit (hoodie, trousers)	33	16
37	Pajamas (jacket, trousers)	21	36
38	Bedspread (waffle)	0	2
39	Towel (waffle)	1	7
40	Towel (with hood)	1	11
41	Bathrobe (with hood)	254	265
Лист1

 

[bebo021999]

I constantly have to manually select rows and group data. Maybe there is a way to write a macro to do this automatically ?

In this sample:
Which rows and data group need to be selected?
Do you mean:
- manually select = hightlight by mouse dragging
or
- built a dynamic SUM with dynamic range
?

 

[Ekmelnikov]

Now I select everything that is not in bold with the mouse and group it manually

But I want to know if it is possible to write some kind of macro for automatic grouping. ( ( Again, I can't set constant cells in the macro, since the number of categories and brands can change from week to week )

In this sample:
Which rows and data group need to be selected?
Do you mean:
- manually select = hightlight by mouse dragging
or
- built a dynamic SUM with dynamic range
?