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

₹600-1500 INR

Đã hoàn thành

Đã đăng vào

gần 6 năm trước

₹600-1500 INR

Thanh toán khi bàn giao

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

Mã dự án: 17522825

Về dự án

3 đề xuất

Dự án từ xa

Hoạt động 6 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@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 trong 1 ngày

4,9

(53 nhận xét)

5,5

3 freelancer chào giá trung bình ₹1.417 INR cho công việc này

@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 trong 0 ngày

4,5

(4 nhận xét)

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 trong 3 ngày