Vba macro code to put year down one by one in the given excel sheet

[Dharani Suresh]

Dear Sir / madam,
I need VBA Macro coding for the output to be appeared like given in the excel sheet, In which I need all the years to appear down one by one along with its months and days. I have attached the excel sheet with this post for your kind reference and perusal and also I did manually for your easy understanding... Like this I have to do for 500 files. Please do help me…

Please oblige and do the needful…
Thanks & Regards,
Dharani Suresh.step 2.xls

[:) Sixthsense :)]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Dharani Suresh]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.


To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

k admin... I will follow your suggestions...
Thank you...

[:) Sixthsense :)]

Thanks for the correction in Thread Title.

But I am unable to understanding what needs to be done in that workbook and based on what

[Dharani Suresh]

Thanks for the correction in Thread Title.

But I am unable to understanding what needs to be done in that workbook and based on what

Dear Sixth Sense,
I need the output to be with the year one by one down(along with its months and days). i have did manually in the excel sheet please down and see you will understand. like this i have to do for 500 files. please help me... i need very urgently..

rgds,
dharani.

[Dharani Suresh]

please ladies and gentlemen, somebody help me answer for this post.. i need it very urgently...

[:) Sixthsense :)]

Still your query is unclear to me...

You may be very clear about your requirement but for us it is a new set of data and without any clear description about what you want and the logic about how it's very hard for us to understand.

[cytop]

Also: http://www.excelforum.com/excel-prog...ne-by-one.html

[Dharani Suresh]

Still your query is unclear to me...

You may be very clear about your requirement but for us it is a new set of data and without any clear description about what you want and the logic about how it's very hard for us to understand.

Dear Sixth Sense,
Thanks for the reply... I think if u see the attached excel file you can understand easily.. where I have did manually. Dear sixthsense, In my file I need all the years to appear down one by one along with its months and days which I have done very clearly in the attached excel file. please do refer that for your kind reference and easy understanding.. again I m attaching the file exclusively for your kind reference..

AWAITING FOR A POSITIVE REPLY FROM YOU..

Thanks & Regards,
Dharani.

[:) Sixthsense :)]

I hope this is what you are looking for...

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[:) Sixthsense :)]

@ cytop,

Thanks for the intimation about the duplicate post.. but I don't know which one I have to call as duplicate post whether this one or that one



@ Dharani Suresh,

Please don't duplicate the post..........

[Dharani Suresh]

[QUOTE= Sixthsense ;3367945]I hope this is what you are looking for...

Please Login or Register  to view this content.

QUOTE]

Dear Sixth Sense,
Thank you so much for the apt answer... My heartfelt thanks to you.. you saved me..
Thank you so much...

but what do you mean by duplicating the post??????? sorry I cannot understand.. I am not doing that... often I am getting this comment.. please help with this, so that from next time I will not do this..

Thanks & Regards,
Dharani.

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep

Regarding Duplicating of Thread please follow the link posted by cytop in Post #8 of this thread.

At the same time please don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.