Create an Excel Macro (VBA) to sort data automatically.
$10-30 USD
Paid on delivery
We have a spreadsheet that comes out of our website that we would like to have reorganized automatically using an Excel Macro. Basically columns will need to be copied over in the correct order and then sorted.
I have attached two files, registration_data_before ([login to view URL]) is what it looks like when it comes out of the site and registration_data_after ([login to view URL]) is how we want it to look. The data sets may not have the same information but you can get the idea of what we want from the column headers. I have also attached a Column Mapping ([login to view URL]) File to show which columns we want to go where.
The client would like a simple button in the ribbon or in the toolbar to activate this change.
They would basically copy and paste the data into the file with the macro and then click the button to activate the macro. The column organization would then be done, the rows should be sorted, and the macro would ask them where they want to save the file and supply a default filename for them to use so they don't have to type it in.
For the Level Column they would like just the number. In the before data you may see: “Level 3 Recreational” but they want just “3”.
Column Organization should reflect the After file.
Row Sorting should be first by Payment (Col L.) showing Incomplete first, then pending, then complete. Secondary row sorting should be by Team Name (Col. A).
File save as name should start with the word registration, then pull the Event Name (col. N) from the original spreadsheet and then add the date that the macro was run (today's date). For example, with the before file attached the event name in col. N is 2016 Reno Memorial Day (always the same in each file - file is exported from the website by event). In this case the default save as filename would be "[login to view URL]" (the date the file was run through the macro being 2-12-16).
The data pasted into the macro should not be allowed to be saved. The saving of the file will be done by the macro. In other words, the macro file should be read only.
I just uploaded an updated Before file.
Basically, I changed the code and it looks like it is exporting Gender and Grade correctly now. It all goes into Col X (i.e. Boys 7th, Girls 12th, etc.). I have uploaded an new column mapping as well.
The items in Col X will need to be split apart and put into separate columns. I believe they can be split on the space to get the gender and the grade level separated.
This new column X data may be blank at times so we don't want the Macro to break if it can't find a space to split the data on.
Project ID: #9663857
About the project
Awarded to:
Hi, I am a scientist by profession with extensive experience in creating Excel templates to import, reformat and export data. I have completed projects similar to this many times in the past, and I believe I will be More
38 freelancers are bidding on average $30 for this job
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr More
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More
Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on projects.
Dear Buyer, I pray and hope that you will give me this project. I am able to hard working. I will trying best for your fully satisfaction. TaNkYou............
I have the expertise in Excel & scripting in VBA and can do this task , quickly and accurately. Ready to start work immediately.
I am an advanced user with over 10 years of MS Office experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft More
Greetings. I am able to modify your file, adding a button that will do all the required processes at the same time and making it very smoothly steps in order to make it fast and friendly for your client. I specialize More
ready to star work from now waiting for your replay so fast and with no error waiting Thanks MR Islam
Completely understood the project objectives. Simply, a little bit of code will do the work. I have experience with several VBA programming projects done both in College and Work.
No problem...I can make you a macro for your problem in just a few days...if there are any questions, just get in touch with me.....kind regards...
i have excellent experience in macro development around 10 years . i would like to work with you i can send the sample send message .
I have been working with software development for over 15 years and will ensure I involve you throughout the project cycle. 1- I will make sure that the scope of the project is well documented. 2 - I will make sure More
Hello! I am ready to carry out the work. I will do at the highest level. I would be happy to start cooperation. Gennady
I have done projects like this before, and would like to do this for you. I have never used freelancer before, but this is a good one to start.
