VBA Excel - import data from web into Microsoft Excel

  • Status Closed
  • Budget N/A
  • Total Bids 2

Project Description

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.

Get free quotes for a project like this

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online