LinkBack URL
About LinkBacks
Dear all,
I need a help to arranged my data. I have daily climate data for 16 stations as in sheet 1 to 21 and I want to extract each station's data in a single sheet as in samaru sheet. Thank you
Dear all,
I need a help to arranged my data. I have daily climate data for 16 stations as in sheet 1 to 21 and I want to extract each station's data in a single sheet as in samaru sheet. Thank you
Try this:
Please Login or Register to view this content.
If you are happy with my response please click the * in the lower left of my post.
Here's my understanding.
Please Login or Register to view this content.
Dear Jindo,
thank you very much for your reply. Please can you work it on my excel file? I don't know much about coding so I couldn't use the script you wrote. Thank you
Dear Stbkynts,
I don't understand much about coding so I wish if you can show me using my excel file. However, I saw Long and I assume longitude in your script. The data are purely stations based and I only want to rearrange the data in such a way that each station's data is in separate sheet instead of 16 stations. Please use my data and work on it. Thanks
Not even close.However, I saw Long and I assume longitude in your script.
That is exactly what I did and it does exactly what you asked.Please use my data and work on it.
Okay. Please can you tell me how I can use the script?I copy the script to my excel data but I don't actually know how to use it so it didn't work. I thought you will attached the excel file you worked on it here. Thanks
I am not able to attach files from this location. You can do a google search on how to add code to the Visual Basic Editor. Here is a small example utilizing a command button. You don't need to use a command button if you don't want to; instead you can put the code in its own module to be called directly.
http://www.excel-easy.com/vba/create-a-macro.html
Some worksheets are deleted due to the size limit of attachment, but doesn't matter.
My code reads all the data from worksheets that named "Sheet#".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks