Closed

Automatically grab spreadsheet from internet and save to a file location

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: Data Entry, Excel

See more: price list excel formula, excel macro file location, automatic data entry in excel, excel spreadsheet formula, csv spreadsheet, Vlookup, save to excel, name to be changed, grab, excel vlookup, automatically, file email extract, spreadsheet price list, excel formula spreadsheet spreadsheet, spreadsheet csv, extract excel files, excel macro csv, excel 2013 formula, simple email macro, vlookup master list csv, daily time series, extract name email excel, excel 2013 macro, macro formula, macro spreadsheet

About the Employer:
( 21 reviews ) Altrincham, United Kingdom

Project ID: #4988988

19 freelancers are bidding on average $50 for this job

pkcyber

I can develop the application for you. See sample app below:: [url removed, login to view] [url removed, login to view]

$100 USD in 2 days
(23 Reviews)
5.4
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop software/macro/bot/ More

$200 USD in 3 days
(33 Reviews)
5.0
alizza

Hello Data Entry and WebScraping Expert here. I am interesting on your project. I assure you 100% accurate and high quality results. Waiting for your positive responds to discuss furthermore about this project. Tha More

$24 USD in 3 days
(29 Reviews)
4.9
amraf

I am willing to start the project immediately. I have 4 years work experience in the field of data entry and web researching. I will complete the project within the time frame with good quality. I am waiting for your r More

$25 USD in 3 days
(8 Reviews)
4.3
shajijohnc

Hello, I have very good experience in data extraction and excel. I am interested in this project. Could you let me know the website and data format you need so that I can generate few sample entries? I can create More

$100 USD in 3 days
(12 Reviews)
3.6
inoussakabore

I can do this for you in the few hour. I have already done it so it is so easy for me. If you look at my profil you will see that i have already done it. I am ready to start.

$25 USD in 3 days
(1 Review)
3.2
gkan1234

Hi I have 4+ years experience in Java. I will do this for you using Java, which will automate the file download process. Thanks

$25 USD in 2 days
(3 Reviews)
3.0
hbxfnzwpf

I am very proficient in dealing with word, ppt, access, excel files, and good at VBA and java programming which will let the scrape much easier, I have exceed 6 years of VBA programming experience now. I did many proje More

$54 USD in 3 days
(1 Review)
2.2
amarjithch

Hello, I am an experienced data entry technician, graduated in computer science.I am willing to work for [url removed, login to view] forward me the details if you are interested.

$20 USD in 3 days
(1 Review)
0.8
avnish84kumar

I understand this requirement. I can do this for you. You can drop me a note to my gmail address# [url removed, login to view] if you consider me for this work.

$30 USD in 1 day
(0 Reviews)
0.0
helpkimberone

Simple project. Should not take long time to finish. I will finish and submit in a day. Please feel free to contact immediately.

$15 USD in 1 day
(0 Reviews)
0.0
Jokic007

Dear, I m ready to work on this project. Please give me more information about it. I m new on this site, but I have a lot of expirience in this kind of jobs. Regards, Marko Jokic

$15 USD in 3 days
(0 Reviews)
0.0
titukhan1001

Dear Sir, Madam, Expert & experience team ready to work. I see ur project [url removed, login to view] very esy work i can do the work accurate perfect in time & i know how to do first work& good knowledge for data [url removed, login to view] fo More

$25 USD in 3 days
(0 Reviews)
0.0
mintupandit4

Hi Sir I am interest do this work. i am new freelancer. but not this type of work. I am confidently tell you i do this work. Regards Tanmoy kumar Pandit

$25 USD in 3 days
(1 Review)
0.0
kapilk101

Hi, I can do this job efficiently as per your requirements. Although new to this site, I have more than 7 years of experience in the filed of Data Entry. I think work speaks better than words. Thanks and have a nice da More

$88 USD in 2 days
(0 Reviews)
0.0
azmanali

Please give me the chance to prove myself in this project and I promised to deliver to you on time. Thank you

$25 USD in 3 days
(0 Reviews)
0.0
Hemanga

I'll do it for you. :) But I need milestone created before we start the project. :) Please award me the project and I'll do it on time as your mentioned desires. Please pmb more details.

$15 USD in 3 days
(0 Reviews)
0.0
ranjeetbtp25

Quality + Efficiency + Experience = Great Work. Please have a look at pm for more details. Your search ends here ranjeetbtp25

$30 USD in 3 days
(1 Review)
0.0
maurodl

Do you want it to be a resident program or do you prefer to launch it manually? I can write a .net program that accomplish what you asked in a couple of days

$111 USD in 2 days
(0 Reviews)
0.0