Automatically grab spreadsheet from internet and save to a file location

CLOSED
Bids
19
Avg Bid (USD)
$50
Project Budget (USD)
$10 - $30

Project Description:
Hi,

This is a very simple task that I’d like to have completed as soon as possible. Our two suppliers release price lists on a regular basis. One of those suppliers updates the pricelist daily so that it can be downloaded whenever I visit a particular web address. The other supplier provides the price list every two days as an attachment to an email (we use Gmail).

I would like someone to create an automatic process whereby the two spreadsheets are downloaded automatically and saved to a particular file location. At present, the worksheets within the supplier spreadsheets have titles which change every time the file is updated. I would like the process to automatically rename the worksheets in each spreadsheet so the worksheets have the same name each time a new spreadsheet arrives from the suppliers. This will enable us to extract data from the spreadsheets.

I have a master spreadsheet which has a vlookup formula to grab data from the supplier spreadsheets. I want the person who completes this task to make sure the vlookup formula works well each time the spreadsheets are updated. The master spreadsheet then manipulates the data. Finally, it contains a macro which, when activated, produces a series of CSV files. I would like this macro to be changed so it produces the CSV files each hour, rather than every time a person decides to run the macro.

Ideally, this entire process should be able to operate without any of the spreadsheets being opened.

Thanks,
Dan

Skills required:
Data Entry, Excel
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 2 days
$ 200
in 3 days
$ 24
in 3 days
$ 25
in 3 days
$ 100
in 3 days
$ 25
in 3 days
$ 25
in 2 days
$ 54
in 3 days
$ 20
in 3 days
Hire avnish84kumar
$ 30
in 1 days