Excel VBA and MySQL Table Creation
Budget: £10 – £400 GBP
I am currently looking for a fully seasoned VBA and MySQL coder to build VBA codes and MySQL codes to generate a new table in MySQL and then the ability to be extracted to my excel file. This file has historical soccer data and the ability to be exported to MySQL.
1. Add aditional code to the "Add to MySQL" button in the League tab.
2. The additional code will generate a duplicate of the betexplorer_2 table from the MySQL and rename it main_table.
3. Remove the URL column from the main_table.
4. Apply the filters to the main_table from columns "Q" and "Y" from the blue table in the in the "Filter_DB" tab.
5. Add aditional columns to the main_table columns "AF-AJ" from the blue table in the "Filter_DB" tab and apply the formulas.
6. Once you have built the new VBA codes to build the new table "main_table" in MySQL (Steps 1-5), this code will run after the first macro has been executed off the "Add to MySQL" button. So in essence the second table will be generated from the the betexplorer_2 table from the MySQL without an additional button.
7. Add a new button for a new macro in the "Filter_DB" tab at cell O5 similar to your existing button and use the colour blue.
8. Clear contents in the "Main Table" in the Main Table tab once the button is pressed.
9. Build, use or modify existing automated codes/queries to pull the data based on the criterias from the first table to the left in the "Filter_DB" tab that we specify from the "main_table" mysql to Excel, "Main Table" tab.
10. Once you have completed (Steps 7-9) in esseence we should be able to click the new blue button and extract the data from the main_table MySQL to the "Main Table" tab in excel and replace any existing data.
11. Once the codes have been executed there will only be values in the excel tables to avoid these heavy slow formulas.
1. Add aditional code to the "Add to MySQL" button in the League tab.
2. The additional code will generate a duplicate of the betexplorer_2 table from the MySQL and rename it main_table.
3. Remove the URL column from the main_table.
4. Apply the filters to the main_table from columns "Q" and "Y" from the blue table in the in the "Filter_DB" tab.
5. Add aditional columns to the main_table columns "AF-AJ" from the blue table in the "Filter_DB" tab and apply the formulas.
6. Once you have built the new VBA codes to build the new table "main_table" in MySQL (Steps 1-5), this code will run after the first macro has been executed off the "Add to MySQL" button. So in essence the second table will be generated from the the betexplorer_2 table from the MySQL without an additional button.
7. Add a new button for a new macro in the "Filter_DB" tab at cell O5 similar to your existing button and use the colour blue.
8. Clear contents in the "Main Table" in the Main Table tab once the button is pressed.
9. Build, use or modify existing automated codes/queries to pull the data based on the criterias from the first table to the left in the "Filter_DB" tab that we specify from the "main_table" mysql to Excel, "Main Table" tab.
10. Once you have completed (Steps 7-9) in esseence we should be able to click the new blue button and extract the data from the main_table MySQL to the "Main Table" tab in excel and replace any existing data.
11. Once the codes have been executed there will only be values in the excel tables to avoid these heavy slow formulas.