Excel VBA code to sync Local excel sheet and another excel sheet saved on google drive

₹600-1500 INR

Completed

Posted

over 5 years ago

₹600-1500 INR

Paid on delivery

Hi, I have 2 excel sheets, which are a copy of each other. One is saved on my local drive (My Laptop), and the other is saved on my google drive. In the sheet saved on the google drive, a colleague can go ahead and change values in certain cells. Currently I have to download the sheet from google drive, look at the changed values and then update my excel sheet (the local excel sheet, on my Laptop). What I want is a VBA code, which I can run on my Local excel, which will fetch values from 3 cells on 3 different tabs on my google drive excel, and then plug those values in my local excel. Its a quick code for anyone who knows how to connect the two Please note: I do not have google drive app on my PC and don't intend to install it as well

Excel

Visual Basic

Visual Basic for Apps

Project ID: 17522825

About the project

3 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@archanaoswal

I know how to extract data from Google Sheets into Excel using VBA. (without installing Google Drive) I have excellent command on MS Excel and Google Sheets. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana

₹1,500 INR in 1 day

4.9

(53 reviews)

5.5

3 freelancers are bidding on average ₹1,417 INR for this job

@REDFEATHERART

HI, I have done similar task. I can do it easily within the time frame. I have been doing these types of task fro 9 years. I AM AN EXPERT AT EXCEL.

₹1,500 INR in 0 day

4.5

(4 reviews)

2.5

@GeorgeVBA

Hi there, I have been working with Excel since the 97 - 2003 version. I specialise in linking Excel with external apps. I would be happy to work on this for you. look forward to hearing from you. Regards George

₹1,250 INR in 3 days