Hi everyone,
I attach here a Excel sheet in which there is daily data for A and B from 1932 to 1960. What I would want is a VBA code that could automaticaly sum the data of all months and then put it on the right cells. I think if someone have a look at the sheet is more easy to understand what i'm talking about.
I've added the first example so that you can see what I want.
Thanks to anyone that helps
HELP.xlsm
I would reformat column a to mm/yy and do a pivot table.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
How can I do that?
I have the problem with leap year. That changes everyting :\
Please can someone give me help on this?
Try this: HELP.xlsm
Dear friend,
This solved my issue! Thank you so much for your kind help!
Regards
No problem. If you are satisfied with the solution please mark the thread as [SOLVED] and kindly add rep by clicking the * below my post.
Thanks,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks