The goal of this project is a development of a fast and efficient Excel 2003 macro that will accumulate
financial data from [url removed, login to view]
Attached is a [url removed, login to view] to which the macro needs to be added. The first worksheet, "REPORT" will contain the symbol entry cell and a button for the macro execution.
When executed, the macro will populate the rest of the workbooks ("SUMMARY", "KSTATS", "COMPETITORS", and "ESTIMATES")
with data for the symbol entered (REPORT!C3) as follows (example data is for Microsoft - MSFT):
SUMMARY worksheet - [url removed, login to view]
KSTATS worksheet - [url removed, login to view]
COMPETITORS worksheet - [url removed, login to view]
ESTIMATES worksheet - [url removed, login to view]
Again, I need VB macro developed - Excel Web Query functionality can not be used.
The macro needs to validate if the data label of the incoming data matches the data label in the template, preventing errors from inconsistent web page layout.
The macro needs to contain code for monitoring of successful execution and display error messages if there were errors during the data download.
Please specify the time you need to develop the macro - I need it ASAP. I will expect you to meet your deadline
and if you do not, I will select another provider.
Thank you for considering my project.