Create Google Sheets with Scripts (we have Excel with Macros today)
$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
Awarded to:
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
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
10 freelancers are bidding on average $181 for this job
We are using google sheet for years now, and make it available for sharing to all our employees