LinkBack URL
About LinkBacks
Hi all. I have this daily precipitation data and I want to arranged it in a new format as appear in Sheet two. I will be grateful if any one can help me out. Thanks
Hi all. I have this daily precipitation data and I want to arranged it in a new format as appear in Sheet two. I will be grateful if any one can help me out. Thanks
the macro is : ParseTbl()
see the RESULTS tab.
parse Data%20for%20arrangement_June_2014(1).xlsm
With 2 macro's
After that I used a recorded macro to get the date sorted.
See the attached file.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi oeldere. This is what iam looking for but I don`t understand the steps you used to rearrange the data. Please can you explain it in simplest form for me? I don`t have limited knowledge in programming and coding. Thank you
Hi. The date were not in proper form. Each month should have up to 31 or 30 or 28 or 29 days as the case may be but your months each end with 12 days. Thank you
You do or you don't?Please Login or Register to view this content.
1) First I fill the data in column A so we got in all cells the year.
I used this macro for it => Sub filldata_ascending_incolumnA_()
2) After that I used a macro to rearange the data.
I used this macro for it => Sub CONVERTROWSTOCOL_Oeldere_revisted()
The sheet with data has the name sheet1 (in my macro)
3) After that i made an table of the data on the output sheet.
4) E2=(A2&"-"&B2&"-"&C2)*1
The format of cell E2 = dd-mm-yyyy
5) After that I used sorting on column E
Hope I explained well.
@akumagaavese
Please also refer to whom you responding.Please Login or Register to view this content.
Hi Oeldere. Sorry for the mistake. I mean I have limited knowledge in programming and coding. I will follow the steps and see if I can rearrange my other data sets. Do I need to start recording macro?
If you have (other) questions, just ask.
Hey. I run the macro but the final date arrangement is becoming difficult for me. The days and month appears in 12. That is days appears as 1, 1,1,........1 corresponding to the months 1, 2, 3-12. How do you make the table? Iam sorry for bothering you.
I changed the months in figures (01 till 12)
See my post.
I have done that to easier get an date of the values.
If you prefer with formula, perhaps this should done that, please have take a look the file attach...
Regards
Azumi
Azumi. Thank you very much. This work for me perfectly. Azumi means fasting in my place.
Yes you're welcome, glad it works
please, if we have the same case but inverted, what i can do????? by using macro????
You get better help on your question if you add a small excel file, without confidential information.
Please also add manualy the expected result in your file.
To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks