VBA Macros to determine last month in a year

[Abdur_rahman]

Hello Again,

I am looking for help for a macros to calculate last month in a same year dynamic months & Years.

Program need to check what his the last month in a year and take that amount for that last year and apply to the remaining months.

Let say the year 2017 having last months is May and the amount is 30. So remaining months Jun, Jul Aug, Sep, Oct, Nov, Dec with applied 30 and count the total amount as 210 for remaining month.

Copy of manual file is attached for your reference.

Thank you.

[Kaper]

Try such code:

Please Login or Register  to view this content.

[LeoTaxi]

Other method,

Please Login or Register  to view this content.

Kind regards
Leo

[Alf]

And a third possible setup.

Please Login or Register  to view this content.

Alf

[Abdur_rahman]

Thanks Kaper & LeoTaxi.

Both of your script is working and LoeTaxi your script is more understandable.

Thank for your support and help.

Sorry Alf just of your script feedback your script is not working.

Topic marked as solved.

[Alf]

Sorry Alf just of your script feedback your script is not working.

Thanks for feedback I also found the formula for calculating the month did not like the month "May" changed it to the Swedish month "Maj" and the I had no problem. Was a bit puzzled as I run an English
version of excel.

Changing Region and Language setting in the windows setting "Format" tab from Swedish to English (United States) solved the "May" problem. Strange that the Windows setting has a higher hierarchy setting than the excel one. Oh well one live and learn.

Alf