VBA Excel - import data from web into Microsoft Excel
This project received 2 bids from talented freelancers with an average bid price of $240 USD.Get free quotes for a project like this
looking to import data for a 12 month period. 100 rows of information per day.
pre recorded basic macro for the date of 16th February 2013 done. file to be supplied. succesfully pulls in data required.
but need to create a loop from user entered parameters in the main excel worksheet ( 4 or 5 ).
eg Excel cell a1 = start date 2012/01/01, b1 = end date 2013/02/16 , c1 = event code SR , d1 = destination range, e1 = other?
so as to extract data over a 12 month period say.
Only 1 error trap required ..... eg on a particular day there may not be a sr event. this date needs to be recorded.
Fixed price easily determined as extended project is a byproduct of already working macro for 1 day. data cleansing / manipulation not required inside current worksheet.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online