select next sheet based on end of month for year previous sheet

[Abdo]

Hi Guys

I need macro when the date of month from the year reach to finshing , then should move to next sheet . every sheet contains date in column A for instance when finish the date of JAN for the year into last row 1/31/ 2020 , then should move to next sheet contains month FEB and when finish the date of FEB for the year into last row 2/28/2020 then should move to next sheet contains month MAR and so on and when finishing DEC month and enter in new year 2021 ,then should start from sheet is relatingfor the new year .
start from this month for this year

month.xlsx
	A	B	C	D	E	F	G
1	ITEM	CODE	DESCIBE	REF	DEL.N	QTY1	QTY2
2	1/1/2020	CMTR11	BIG-DTR11	RE41	DL-121	4576	76
3	1/1/2020	CMTR21	BIG-DTR21	RE51	DL-13	67	89
4	1/1/2020	CMTR3	BIG-DTR3	RE6	DL-14	87	346
5	1/2/2020	CMTR4	BIG-DTR4	RE7	DL-15	34	87
6	1/3/2020	CMTR5	BIG-DTR5	RE8	DL-16	341	78
7	1/4/2020	CMTR6	BIG-DTR6	RE9	DL-17	890	7890
8	1/15/2020	CMTR7	BIG-DTR7	RE10	DL-18	90	433
9	1/15/2020	CMTR8	BIG-DTR8	RE11	DL-19	876	700
10	1/16/2020	CMTR9	BIG-DTR9	RE12	DL-20	45	800
11	1/17/2020	CMTR10	BIG-DTR10	RE13	DL-21	67	900
12	1/18/2020	CMTR12	BIG-DTR12	RE15	DL-23	98	1100
13	1/19/2020	CMTR13	BIG-DTR13	RE16	DL-24	76	88
14	1/20/2020	CMTR14	BIG-DTR14	RE17	DL-25	54	90
15	1/28/2020	CMTR15	BIG-DTR15	RE18	DL-26	67	87
16	1/29/2020	CMTR16	BIG-DTR16	RE19	DL-27	67	87
17	1/30/2020	CMTR17	BIG-DTR17	RE20	DL-28	67	87
18	1/31/2020	CMTR18	BIG-DTR18	RE21	DL-29	67	87
sheet1

when finish the month should move to this sheet

month.xlsx
	A	B	C	D	E	F	G
1	ITEM	CODE	DESCIBE	REF	DEL.N	QTY1	QTY2
2	2/10/2020	CMTR11	BIG-DTR11	RE41	DL-121	300
3	2/10/2020	CMTR21	BIG-DTR21	RE51	DL-13		22
4	2/11/2020	CMTR3	BIG-DTR3	RE6	DL-14	1	346
5	2/12/2020	CMTR4	BIG-DTR4	RE7	DL-15	22	87
6	2/13/2020	CMTR5	BIG-DTR5	RE8	DL-16	34	6
7	2/14/2020	CMTR6	BIG-DTR6	RE9	DL-17	55	66
8	2/15/2020	CMTR7	BIG-DTR7	RE10	DL-18	90	66
9	2/15/2020	CMTR8	BIG-DTR8	RE11	DL-19	876	67
10	2/15/2020	CMTR9	BIG-DTR9	RE12	DL-20	45	34
11	2/16/2020	CMTR10	BIG-DTR10	RE13	DL-21	67	22
12	2/17/2020	CMTR12	BIG-DTR12	RE15	DL-23	98	12
13	2/18/2020	CMTR13	BIG-DTR13	RE16	DL-24		11
14	2/19/2020	CMTR14	BIG-DTR14	RE17	DL-25		90
15	2/28/2020	CMTR15	BIG-DTR15	RE18	DL-26		87
sheet2

and when finsh FEB then should move to next sheet for month MAR

month.xlsx
	A	B	C	D	E	F	G
1	ITEM	CODE	DESCIBE	REF	DEL.N	QTY1	QTY2
2	3/1/2020	CMTR11	BIG-DTR11	RE41	DL-121	12	22
3	3/1/2020	CMTR21	BIG-DTR21	RE51	DL-13	2	1
4	3/1/2020	CMTR3	BIG-DTR3	RE6	DL-14	11	22
5	3/1/2020	CMTR4	BIG-DTR4	RE7	DL-15	22	22
6	3/2/2020	CMTR5	BIG-DTR5	RE8	DL-16	34	22
7	3/2/2020	CMTR6	BIG-DTR6	RE9	DL-17	44	44
8	3/2/2020	CMTR7	BIG-DTR7	RE10	DL-18	442	66
9	3/3/2020	CMTR8	BIG-DTR8	RE11	DL-19	222	67
10	3/4/2020	CMTR9	BIG-DTR9	RE12	DL-20	111	34
11	3/5/2020	CMTR10	BIG-DTR10	RE13	DL-21	114	22
12	3/6/2020	CMTR12	BIG-DTR12	RE15	DL-23	23	12
13	3/7/2020	CMTR13	BIG-DTR13	RE16	DL-24		11
14	3/8/2020	CMTR14	BIG-DTR14	RE17	DL-25		90
15	3/9/2020	CMTR15	BIG-DTR15	RE18	DL-26		87
16	3/10/2020	CMTR16	BIG-DTR16	RE19	DL-27		88
17	3/11/2020	CMTR17	BIG-DTR17	RE20	DL-28		89
18	3/12/2020	CMTR18	BIG-DTR18	RE21	DL-29		90
19	3/13/2020	CMTR19	BIG-DTR19	RE22	DL-30		91
20	3/14/2020	CMTR20	BIG-DTR20	RE23	DL-31		92
21	3/15/2020	CMTR21	BIG-DTR21	RE24	DL-32		93
22	3/16/2020	CMTR22	BIG-DTR22	RE25	DL-33		94
23	3/17/2020	CMTR23	BIG-DTR23	RE26	DL-34		95
24	3/18/2020	CMTR24	BIG-DTR24	RE27	DL-35		96
25	3/19/2020	CMTR25	BIG-DTR25	RE28	DL-36		97
26	3/20/2020	CMTR26	BIG-DTR26	RE29	DL-37		98
27	3/21/2020	CMTR27	BIG-DTR27	RE30	DL-38		99
28	3/22/2020	CMTR28	BIG-DTR28	RE31	DL-39		100
29	3/23/2020	CMTR29	BIG-DTR29	RE32	DL-40		101
30	3/24/2020	CMTR30	BIG-DTR30	RE33	DL-41		102
31	3/25/2020	CMTR31	BIG-DTR31	RE34	DL-42		103
32	3/26/2020	CMTR32	BIG-DTR32	RE35	DL-43		104
33	3/27/2020	CMTR33	BIG-DTR33	RE36	DL-44		105
34	3/28/2020	CMTR34	BIG-DTR34	RE37	DL-45		106
35	3/29/2020	CMTR35	BIG-DTR35	RE38	DL-46		107
36	3/30/2020	CMTR36	BIG-DTR36	RE39	DL-47		108
37	3/31/2020	CMTR37	BIG-DTR37	RE40	DL-48		109
sheet3

 

[Abdo]

is there any help ?

 

[Abdo]

 

[Abdo]

cross poted in this forum

select next sheet based on ending of month for year for previous sheet

 

[Abdo]

it's been solved by mr.jindon
here is the solution if anybody interests

Sub test()
    Dim ws As Worksheet
    Set ws = IIf(ActiveSheet.Index = Sheets.Count, Sheets(1), ActiveSheet.Next)
    With Range("a" & Rows.Count).End(xlUp)
        If WorksheetFunction.EoMonth(.Value, 0) = .Value Then
            Application.Goto ws.[a1], True
        End If
    End With
End Sub