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

[abdo M]

I need to macro when the date of month for the lastrow 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 relating for the new year from JAN month and so on for new year .
sorry I can't post the result because depends on select the sheet for eavery lastrow contains ending of month for the year .
when repeat the finishing of date should depend on the last row .
also I posted here
https://www.mrexcel.com/board/thread...sheet.1226725/

[kvsrinivasamurthy]

Try

Please Login or Register  to view this content.

[abdo M]

thanks.
can you check the file ,please?
it shows MsgBox "Sheet not Found when the sheet3 is active , then should move to next sheet4 , but it doesn't happen .
I no know what my mistake !

[kvsrinivasamurthy]

In previous file it is given that the sheet starts from 1st of month. This file starts from 20th of the month. I.

Please Login or Register  to view this content.

[abdo M]

thanks . not always the date will start day from 1 . could be 12, 15 ,20 ....
it doesn't seem to work

[kvsrinivasamurthy]

This code is working for me.

Please Login or Register  to view this content.

[jindon]

Simply

Please Login or Register  to view this content.

[abdo M]

@kvsrinivasamurthy now it works greatly و but not like jindon's code . your code depends on Sequentially based on successive months
but not always the months will be successively .
@ jindon your code is awesome !
but guys ,did you read this ?

and when finishing DEC month and enter in new year 2021 ,then should start from sheet is relating for the new year from JAN month and so on for new year .

when finish year 2020 should move to the next sheet start from 2021 year and when finish year 2021 should move the next sheet start from 2022 year and so on when enter new year
thanks for you .

[jindon]

Explain when you are at last sheet, what should happen?

Doesn't matter what year/ month it is.

[abdo M]

Explain when you are at last sheet, what should happen?

when finish year should move to next sheet start from new year whatever starting the month
if I have the last sheet start date 02/15/2021
and precede last sheet 06/30/2020 contains ending of the month for previous year , then will move to last sheet until finishing for the last mont for 2021 year up to last sheet contain 2021 and if the last sheet start from 05/15/2022 and precede last sheet sheet 31/09/2021 contains ending of the month for previous year then will move to last sheet and move to next sheet until finishing 2022 year
ending of year for last month for the last sheet will move to next sheet contains new year.

[jindon]

No, you are not answering to my question.

Whatever the year/month the last sheet, say Dec/2022.
It is the last sheet.
What should happen next?

Create a new sheet? or what?

[abdo M]

Create a new sheet? or what?

yes I will creat new sheet for the next year 2023, then will move from last sheet DEC 2022 to sheet strating from 2023 year and will move to next sheet until finish 2023 year and repeat this process for next year.

[jindon]

Then what's wrong with my code?

My code returns to the first sheet after the last sheet.

[abdo M]

Then what's wrong with my code?

my apologies !!
I made mistake without finish the last day of the month in the last row for last sheet
Sorry for wasting your time unnecessarily
thanks very much for your solution and time

[kvsrinivasamurthy]

What about my revised code in post#6.

[abdo M]

What about my revised code in post#6.

I have ever told you in post#8

your code depends on Sequentially based on successive months
but not always the months will be successively .