How to write a macro in excel 2016 to reorganize data

N is 2016 Reno Memorial Day (always the same in each file - file is exported from the website by event). For example, with the before file attached the event name in col. N) from the original spreadsheet and then add the date that the macro was run (today's date). A).ДЇile save as name should start with the word registration, then pull the Event Name (col. Secondary row sorting should be by Team Name (Col. Row Sorting should be first by Payment (Col L.) showing Incomplete first, then pending, then complete. In the before data you may see: вЂњLevel 3 RecreationalвЂќ but they want just вЂњ3вЂќ.Д¬olumn Organization should reflect the After file. 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.ДЇor the Level Column they would like just the number. They would basically copy and paste the data into the file with the macro and then click the button to activate the macro. The client would like a simple button in the ribbon or in the toolbar to activate this change. I have also attached a Column Mapping () File to show which columns we want to go where. 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 attached two files, registration_data_before () is what it looks like when it comes out of the site and registration_data_after () is how we want it to look.

Basically columns will need to be copied over in the correct order and then sorted.

We have a spreadsheet that comes out of our website that we would like to have reorganized automatically using an Excel Macro.

How to write a macro in excel 2016 to reorganize data