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

Completed Posted 6 years ago Paid on delivery
Completed 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!

Excel Google App Engine JavaScript

Project ID: #16521106

About the project

10 proposals Remote project Active 5 years ago

Awarded to:

cgullapalli

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 More

$150 USD in 1 day
(857 Reviews)
8.0
murtaza896

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 googl More

$100 USD in 5 days
(2 Reviews)
2.5

10 freelancers are bidding on average $181 for this job

dvcontact

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 be More

$150 USD in 3 days
(48 Reviews)
6.3
usmanhassan123

A proposal has not yet been provided

$250 USD in 1 day
(72 Reviews)
6.2
profydev

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 fur More

$350 USD in 1 day
(23 Reviews)
5.6
dukedias

We are using google sheet for years now, and make it available for sharing to all our employees

$233 USD in 7 days
(0 Reviews)
0.0
lisavillar

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0