split data to multiple sheets based on month and summing the values

[MKLAQ]

hello
I have data in sheet ENTER what I want creating multiple sheets for JAN up o DEC it should copy data from sheet ENTER to sheet relating the month based on COL A in sheet ENTER for instance any data are in JAN month then should copy to sheet JAN and so on the rest of sheets and if I change the data in sheet ENTER then should update the relating sheet months and show the total
sheet ENTER

REPORT (2).xlsx
	A	B	C	D	E
1	DATE	BRAND	TYPE	MODEL	QTY
2	1/1/2021	CC-SS	BMW	2010	250
3	1/2/2021	CC-SS	BMW	2011	125
4	1/3/2021	CC-SS	BMW	2013	66
5	1/4/2021	CC-MM	MER	2020	55
6	2/5/2021	CC-MM	MER	2021	88
7	2/6/2021	CC-MM	MER	2017	99
8	2/7/2021	CC-LL	AUDI	2011	14
9	2/8/2021	CC-LL	AUDI	2015	12
10	3/9/2021	CC-LL	AUDI	2016	15
ENTER

desire result
sheet JAN

REPORT (2).xlsx
	A	B	C	D	E
1	DATE	BRAND	TYPE	MODEL	QTY
2	1/1/2021	CC-SS	BMW	2010	250
3	1/2/2021	CC-SS	BMW	2011	125
4	1/3/2021	CC-SS	BMW	2013	66
5	1/4/2021	CC-MM	MER	2020	55
6	LTT				496
JAN

sheet FEB

REPORT (2).xlsx
	B	C	D	E	F
2	2/5/2021	CC-MM	MER	2021	88
3	2/6/2021	CC-MM	MER	2017	99
4	2/7/2021	CC-LL	AUDI	2011	14
5	2/8/2021	CC-LL	AUDI	2015	12
6	LTT				213
FEB

sheet MAR

REPORT (2).xlsx
	A	B	C	D	E
1	DATE	BRAND	TYPE	MODEL	QTY
2	3/9/2021	CC-LL	AUDI	2016	15
3	LTT				15
MAR

 

[MKLAQ]

I know that but now I'm sure 100% the problem is language in PC it ignores the sheets "JAN,FEB,MAR ,APRIL" as in your file it creates sheets based on language of PC even if so that, there is a problem it doesn't copy the data in right location in sheet month see the last row when enter in sheet ENTER .
last thing if there is way to enforce create sheets month by English by used array (JAN,FEB,MAR...etc)

MKLAQ.xlsm
	A	B	C	D	E	F
1	ID	DATE	BRAND	TYPE	MODEL	QTY
2	CC-SS-BMW-2010	01/01/21	CC-SS	BMW	2010	250
3	CC-SS-BMW-2011	02/01/21	CC-SS	BMW	2011	125
4	CC-SS-BMW-2013	02/01/21	CC-SS	BMW	2013	66
5	CC-MM-MER-2020	04/01/21	CC-MM	MER	2020	55
6	CC-MM-MER-2021	05/02/21	CC-MM	MER	2021	88
7	CC-MM-MER-2017	06/02/21	CC-MM	MER	2017	99
8	CC-LL-AUDI-2011	07/02/21	CC-LL	AUDI	2011	14
9	CC-LL-AUDI-2015	07/02/21	CC-LL	AUDI	2015	12
10	CC-LL-AUDI-2016	09/03/21	CC-LL	AUDI	2016	15
11	CC-LL-AUDI-2019	01/01/21	CC-LL	AUDI	2019	12
12	CC-LL-AUDI-2020	01/01/21	CC-LL	AUDI	2020	1
13	CC-LL-AUDI-2010	01/05/21	CC-LL	AUDI	2010	1
14	CC-LL-AUDI-2002	05/01/21	CC-LL	AUDI	2002	2
ENTER

Cell Formulas
Range	Formula
A2:A14	A2	=C2&"-"&D2&"-"&E2

and see in sheet JAN how becomes

MKLAQ.xlsm
	A	B	C	D	E	F
1	ID	DATE	BRAND	TYPE	MODEL	QTY
2	CC-LL-AUDI-2020	01/01/21	CC-LL	AUDI	2020	1
3	2002	2			2020
4	LTT
5
jan

Cell Formulas
Range	Formula
A2	A2	=C2&"-"&D2&"-"&E2

 

[mumps]

The problem may be caused by the date format that your computer system uses in your country. If you are in Europe, the default date is different from that used in Canada. Cell B14 in your post has 05/01/2021. The macro may be reading the month as 01 which is January instead of 05 which is May.

 

[MKLAQ]

I entered to setting format date by control panel and this what I found dd/MM/yy what I suppose to change

 

[MKLAQ]

I tried with another PC I delete any sheet after sheet ENTER and add the data from COL B : F to create the sheets based on month and copy data to over it , but the code make much confusion first it gives me error subscript out of range

 Set ws = Sheets(Left(MonthName(Month(Target)), 3))

and disable the code in worksheet change event
I enable again by this

Sub nn()

Application.EnableEvents = True

End Sub

then run and create the month MAR normally but way of showing is unorganized and if I return add new data for the same month it doesn't copy to relating sheet month and return showing error again I put the right way how should show the data in the file I no know if your code does that

MKLAQ (1)

 

[mumps]

Your link isn't working properly. Please use box.com or dropbox.com.

 

[MKLAQ]

why it doesn't work the link I entered and download the file normally

 

[MKLAQ]

Box

 

[mumps]

Click here for your file. I have made some changes to the macro, tested it and it works properly. Please keep in mind that there are many criteria that the macro has to check. Test it and see how it works.

 

[MKLAQ]

thanks very much now there is no error but I have some thing need fixing it .

1- I would highlight the last row LTT by gray and bold the font word LTT.

2- when create the months it doesn't create by English as what I want , is there any way to enforce creating sheets by English or I have to reinstall the WINDOWS 10 by English to do that ?

 

[mumps]

Click here for your file.