The goal of this project is a development of a fast and efficient Excel 2003 macro that will accumulate
financial data from [login to view URL]
Attached is a [login to view URL] 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 - [login to view URL]
KSTATS worksheet - [login to view URL]
COMPETITORS worksheet - [login to view URL]
ESTIMATES worksheet - [login to view URL]
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.