Vba macro code for generating years along the side of days and also by removing the months

[Dharani Suresh]

Respected Sir / Madam,
Please do help me with the VBA macros code for generating the output given in the attached excel sheet.

I need the output to be like this. that is,
1) the months must be removed and
2) in the left side, i must get the years till its end. and finally,
3) the empty cells has to be removed. (since in few months we don’t have 31 days and i had yellowed the part for your easy understanding).

pls generate code to give output like this.. please help me... I have done manually and I have attached the excel sheet for your kind reference and perusal. Like this I have to do for 65 files…

please oblige and do the needful..
Thanks & Regards,
Dharani.


PS.,
hope I am not doing any mistake in this post...

[jindon]

Not clear....

Please Login or Register  to view this content.

[Dharani Suresh]

Not clear....

Please Login or Register  to view this content.

Dear Jindon,

Thank you for the quick response.. The answer you gave is exactly right … but it is giving only the half output what I required. It is not giving the second half what I required. Ya obviously I can understand it is little bit not clear only. For your kind reference and for easy understanding I’m attaching you the excel file by quoting my doubt little more clearly in that sheet.

Awaiting for the positive reply..
Thanks & Regards,
Dharani.

[jindon]

No idea about the numbers in Col.O.

[Dharani Suresh]

No idea about the numbers in Col.O.

Dear Jindon,
Thanks for the reply... Numbers in the col O is the numbers as same as in the column A only.. from column A only I am asking you to remove the months name and empty cells and like col O only I need output....Hope u understand now.. I m not confusing you..

AWAITING FOR A POSITIVE REPLY FROM YOU... I NEED IT VERY URGENTLY.. PLEASE HELP ME ....

[jindon]

Please Login or Register  to view this content.

[Dharani Suresh]

Please Login or Register  to view this content.

Dear Jindon,
Thank you for the apt answer.. thank for your great efforts... but sir please one more modification has to be made in the code. that is, in the output what your code is giving is right but in that column years are coming in between which I don't want ... ( it is enough if its come in the side only)please do this modification only and give me please...

please oblige and o the needful...

Thanks & Regards,
Dharani.

[Dharani Suresh]

Thank you jindon... for the effort u made to help me...

Thanks & Regards,
Dharani.

[jindon]

I don't think I understand what you are trying to do, so wait for someonbe else to come in to help you.

[Dharani Suresh]

I don't think I understand what you are trying to do, so wait for someonbe else to come in to help you.

Dear Jindon,
No problem Jindon, somehow the other I managed to complete my work with your code itself... and now I completed also.. thank you so much...

Thanks & Regards,
Dharani Suresh.