Find Jobs
Hire Freelancers

Create Google Sheets with Scripts (we have Excel with Macros today)

$30-250 USD

Completed
Posted about 6 years ago

$30-250 USD

Paid on delivery
We are a wholesale distributor of products with a fairly simple Excel Spreadsheet and some simple macros to make it more user friendly. Basically, it's a tool where the order-taker can add a customer to the queue which is displayed on a TV in the warehouse. Then, a warehouse associate assigns themselves to the order. When complete, the warehouse associate completes the job and it's removed from the queue. Those three transactions are time-stamped so we can later see the amount of time between creation/assignment and assignment/completion. HOWEVER, there is too much lag when we share the document on our network with multiple users. So, my thought was to try Google Sheets. Problem is that I don't know Google Sheets. Do you? If so, can you create a functioning tool for us? I'm completely open to functional improvements (perhaps a Google form for the input) and style improvements. Attached is what we have today in Excel. Thank you!
Project ID: 16521106

About the project

10 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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:
User Avatar
Hi, I am good at Excel vba and google scripts. I have reviewed the details of the macro file. It is possible to have with google sheets. I have created similar ones earlier. Looking forward to work on the project. I would like to know more about the macro part. -Chandra
$150 USD in 1 day
5.0 (857 reviews)
8.0
8.0
User Avatar
I have started working with Google App script in order to upgrade from Excel macros to cloud based sheets, so i completely understand your approach towards the problem, i have worked on more than 50 such personal google sheets automation projects. Technology used: 1. Google Drive 2. Gsuite ( Google Sheets, Google Forms, etc) 3. Google App script
$100 USD in 5 days
5.0 (2 reviews)
2.5
2.5
10 freelancers are bidding on average $181 USD for this job
User Avatar
Hi, You won’t make the right candidate selection without knowing what your project on building a functional Google sheet document with scripts will look like. Fortunately, I can show you how your job will look like before you award the project. Before you award the project, I will provide a sample of this project, so you can be confident of the hands you’ve entrusted this task. If you’re satisfied with what you see, you’ll want to award the project so I can complete it professionally . I’m ready to start working on a FREE sample right away. Hope to hear from you soon
$150 USD in 3 days
4.9 (48 reviews)
6.3
6.3
User Avatar
A proposal has not yet been provided
$250 USD in 1 day
4.7 (72 reviews)
6.2
6.2
User Avatar
Hi i can create google app script to insert order in spreadsheet. i have done same work before, submit user form data to spreadsheet date and month wise. i will finish this work in 1 day. send me message for little further discussion. thank you.
$350 USD in 1 day
4.8 (23 reviews)
5.6
5.6
User Avatar
We are using google sheet for years now, and make it available for sharing to all our employees
$233 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Concord, United States
5.0
6
Payment method verified
Member since Aug 14, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.