Link excel to google sheets, set up automation of excel/google sheets

$30-250 USD

Completed

Posted

over 6 years ago

$30-250 USD

Paid on delivery

I have an excel file that pulls store sales info data from my computer database. It has an “refresh button” on the excel sheet that refreshes per week. I would like to change that to where I can refresh per day. Then I need the information that I pull daily into excel to automatically go into google sheets. Then from google sheets I want to create a report that gets emailed to me with yesterday’s sales, week to date sales and Month to date sales. I also need to set a task on my computer to where it will open a program daily and press a transmit button so data can get transferred.

Excel Macros

Google App Engine

T-SQL (Transact Structures Query Language)

Project ID: 15743707

About the project

5 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:

@insidenetsoft

Hi, We could analyze the the macro that is updating your data in order to bring your desired improvements. We will take the tasks step by step and will decide the price together. My last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that send emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation Don't hesitate to contact me on chat to discuss the solutions for your project. Regards, Marius

$30 USD in 5 days

5.0

(4 reviews)

3.7

5 freelancers are bidding on average $107 USD for this job

@schoudhary1553

Greeting, I have understood your automation of excel/google sheets task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Excel Macros, Google App Engine, T-SQL (Transact Structures Query Language) Proposed Milestones $250 USD - Link excel to google sheets, set up automation of excel/google sheets

$250 USD in 3 days