Hi,
Currently I'm employed by one of the major retailers in the UK working as site merchandising analyst. I'm developing VBA projects to support automated reporting. With my previous job I've developed a mysql to excel data exchange project. A Moodle e-learning platform was serving as a corporate Intranet. The installation was running on mysql database. Number of web forms were used to submit data by flight crew from various destinations around Europe. In the main technical base, Excel application, developed by me, was with a his of one button retrieving data from there data tables (mysql credentials were hard coded in VBA) - bringing the current status into Excel. With the use of tables, pivot tables and additional VBA scripting I was able to create bespoke reports, that were 'always' up to date. I believe with your request I could use this model. On the side of what you want to do with the data in Excel there is an endless list of possibilities including creating interactive dashboards. I'm happy to discuss the options further and I'm certain that if you decide to take me to complete the project this could be start to a fruitful cooperation for the future. The ETA for this project is 2 days, but please know that I'm working full time, which leaves me evenings and weekend days. I would ideally complete the project over the weekend, but would preferably to get all the data needed to start working asap. Kind regards,
Rafal