How To Create Multiple Sheets(With Criteria) From One Sheet?

[xlmaniac]

Dear All,
I do have a sample data set across A1:E20 as follows in the Sheet NameUMP. Rows in this column could go upto 30000.

DUMP is the input sheet based on which multiple sheets need to be created.
In this scenario there are 2 unique count of categories namely FMCG & Staples.
So 2 different sheets need to be created with name of FMCG & Staples.
Sheet number will depend on the Unique count of categories under Column A in DUMP sheet and accordingly the sheet names will also be created.
Now under each sheet, that will be created from Column A, the summary in the different sheets would be as follows.
FMCG sheet should have the summary as follows:-

SKU should be sorted based on the total aggregated qty on descending mode as shown above.
Similarly Staples sheet summary should also be as follows:-

The tasks will be as follows:-
1)Creation of "N" number of sheets based on the Unique Count of Categories under Column A under DUMP sheet.
2)Sheet name would be based on the Category type mentioned in the Column A of DUMP sheet.
3) Every created sheet needs to contain a summary as shown above.
4)SKU needs to be sorted based on the total aggregated qty in descending mode.

Please help.
This would save substantial manual time being wasted now.
Regards

 

[Kerryx]

I know this is not what you asked but why not use pivot tables to show the data, add a slicer/ filter to display each Category as needed

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Cat	Store	SKU	SKU Desc.	Qty
2	FMCG	1	33975	a	18
3	FMCG	1	29018	b	23		Sum of Qty		Store
4	FMCG	1	14414	c	21		SKU	SKU Desc.	1	2	3	4	Grand Total
5	FMCG	1	13696	d	40		33975	a	4				4
6	FMCG	1	12709	e	21		13696	d	12	21			33
7	FMCG	2	21080	x	15		12709	e			26		26
8	FMCG	2	14362	y	30		14362	y		11	33		44
9	FMCG	2	15942	z	5		24859	f				36	36
10	FMCG	3	30908	s	38		35643	g	38				38
11	FMCG	3	13696	d	4		29494	t			39		39
12	FMCG	4	33975	a	32		19422	u			10		10
13	FMCG	4	29018	b	5		40017	i				4	4
14	FMCG	4	24859	f	40		Grand Total		54	32	108	40	234
15	FMCG	4	35643	g	27
16	FMCG	4	24844	h	35
17	FMCG	1	28385	j	5
18	Staples	1	35643	g	38
19	Staples	1	13696	d	12
20	Staples	1	33975	a	4
21	Staples	3	12709	e	26
22	Staples	3	29494	t	39
23	Staples	3	14362	y	33
24	Staples	3	19422	u	10
25	Staples	4	40017	i	4
26	Staples	4	24859	f	36
27	Staples	2	13696	d	21
28	Staples	2	14362	y	11
DUMP