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

₹600-1500 INR

완료함

게시됨

5년 이상 전

₹600-1500 INR

제출할때 지불됩니다

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

프로젝트 ID: 17522825

프로젝트 정보

3 제안서

원격근무 프로젝트

활동 중 6년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@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 1일에

4.9

(53 건의 리뷰)

5.5

3 이 프로젝트에 프리랜서들의 평균 입찰은 ₹1,417 INR입니다.

@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 0일에

4.5

(4 건의 리뷰)

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 3일에