Automatically grab spreadsheet from internet and save to a file location - repost

Closed

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: Copy Typing, Data Entry, Data Processing, Excel, Word

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

Project ID: #4993576

12 freelancers are bidding on average $25 for this job

hbxfnzwpf

I am very proficient in dealing with 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 projects just very simil More

$49 USD in 2 days
(2 Reviews)
2.9
echo17

im a hardworking person. im very dedicated to my craft and work. and im willing to work anytime or anyday.

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

I, Nenad, the customs officer that I have more than 20 years working on data entry, copying files, word processing, designing presentations using Microsoft Office and more as a confirmation of the completed application More

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

Hai,make it sure i complete your project be on time with error free.optimistic,efficiency.so i can able do to do your work.i am looking forward to work with you.

$10 USD in 3 days
(0 Reviews)
0.0
ddyou2002

i ca do this job it is easy and i like it thiis price is given to start with freelancer. and i able to do this task with a script program i am specialist in data

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

I am interested to do the job that you need quickly, because this job was in accordance with the skill that I have. I hope we can work together for a time that we will agree on Best Regards

$25 USD in 1 day
(0 Reviews)
0.0
drgurunathan

I have a proven track record in successfully completing such tasks for a major MNC client; I have a proven track record in successfully completing such tasks for a major MNC client

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

Hello, im ready for this project,u can choose my skill for create your data. My last education S1

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

Hello sir. Thanks for allowing me to submit my bid. I went through the post and read your requirements You need automation for the this job. I can automate the updation process from the two suppliers and re More

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

I'm good in Data Processing (Word, Excel, Power Point), Data Entry, Very good in Typing, Administration Processing, familiar using Internet . im also as student who need use more money and look a part time job .

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

hi, Dear Sir/Madam, I 'am a Designer , Artist, & Animator. I have lot of experience in this field. Dear Sir/Madam, Your job will be attended by me with my hands-on experience in this field and hope you wi More

$25 USD in 2 days
(0 Reviews)
0.0
ajayrathi1809

COMPLETE WORK IN PROFESSIONAL MANNER. ALTHOUGH I AM NEW AT FREELANCER BUT I TRUSTWORTHY TO U. PLEASE GIVE WORK YOU WANT BE DISAPPOINTED.

$23 USD in 3 days
(0 Reviews)
0.0