Closed

Programme / Excel VBA

I would like to create a simple programme (or even just excel VBA) to facilitate the pick and pack process in the warehouse.

I have an excel where I see all new incoming orders I receive everyday including unique order IDs, and the product and quantity for each order.

What I want to achieve is the following:

1. My staff will use a barcode scanner to scan the unique order ID on a printed receipt

2. The screen (the programme or excel) will show the product and quantity in that order

3. My staff will use a barcode scanner to scan the product. If there is any mistake, there should be an error message popping up immediately

4. Log the number of orders and products that have been packed

Any solution is welcome!

Thanks

Skills: Excel, Visual Basic, Visual Basic for Apps, Software Architecture, Data Processing

See more: excel vba project examples, vba language, vba excel examples, useful vba codes for excel, excel vba programming for dummies, vba excel pdf, vba excel download, vba excel 2016, excel vba error, excel vba add installation, excel vba xml post, excel vba menu code, excel vba word style heading, excel vba access vba, simple excel vba, excel vba macro paste adjacent column, excel vba lock sheet user script, sql access excel vba, find text web site excel vba, chart excel vba

About the Employer:
( 1 review ) Central, Hong Kong

Project ID: #24604816

53 freelancers are bidding on average $389 for this job

jaylancer43

Hello Sir, I have read details to log the number of orders and products that have been packed automatically including identifying any mistakes and I can do it. My name is Jay and I'm an Expert Excel and VBA programme More

$555 USD in 3 days
(772 Reviews)
8.5
schoudhary1553

Hello, I can help you with your project - Programme / Excel VBA I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several p More

$500 USD in 10 days
(381 Reviews)
8.0
asin1987

Dear Employer, I will do your Excel based job. Please message me to discuss further. I have been doing more than 13 years of experience working on these jobs. Thanks and Regards, Ash

$500 USD in 7 days
(225 Reviews)
7.9
P0L

Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$300 USD in 3 days
(370 Reviews)
7.5
ineedWorkJob

Greetings sir, I have read your project details and i will develop a windows based standalone solution for you that will help your staff/user to facilitate the pick and pack process in the warehouse. Sir, i can d More

$500 USD in 1 day
(237 Reviews)
7.1
khushh07

Hello... Greetings to you !! I am an excel expert and interested to work with your project. I assure you of a high-quality job. Please let me know when we can start.. Thanks

$400 USD in 7 days
(264 Reviews)
7.1
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I would like to help you create the tool you need. I have More

$250 USD in 4 days
(251 Reviews)
7.0
OutsourceMan

Greetings Wilson C., I am Raman. We can help you with programyou / excel vba. We have completed more than 20+ projects in last few months. Can we discuss more and get started. Thank you for your time and consider More

$306 USD in 7 days
(59 Reviews)
6.7
DanielVizcaya91

Hello there, my name is Daniel. I am not sure I completely understand the process that the program needs to automate, but I would love to help you solve as it seems like a very interesting challenge. I can guarantee an More

$500 USD in 15 days
(113 Reviews)
7.0
rinabuoy13

Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$250 USD in 7 days
(147 Reviews)
6.5
gokulanand

Hello I can get you a Excel VBA script developed for this task. I can get it done in the next 24 to 36 hours. Please share me the data file to understand it better. Thanks Gokul

$250 USD in 2 days
(129 Reviews)
6.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$300 USD in 3 days
(150 Reviews)
6.2
finecodervw

Hi, Keen to work on this project. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It More

$250 USD in 5 days
(174 Reviews)
6.3
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I can develop a fully automated solution which will be able to read the s More

$250 USD in 3 days
(137 Reviews)
5.9
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radi More

$250 USD in 3 days
(94 Reviews)
5.7
daniyal3214

Hi, I have a unique, dynamic and user friendly solution in mind which would fulfill each aspect of your requirements. I am a professional Excel based programmer holding years of experience. I will be happy to discuss i More

$250 USD in 1 day
(65 Reviews)
5.6
shahinrahimi

Hi, I'm interested in your project. I can create it via Python or VBA-Macro. could you share more details on the project and your requirements? I have rich experience in VBA-Macro(Excel, Powerpoint,Access Word, Web scr More

$250 USD in 3 days
(54 Reviews)
5.3
AlexandrUKR

~20Y of VBA, Excel, Access experience, please clarify the barcode scanner software and clarify data template for an order product/ quantity information keeping, i can provide first draft for your test within 3-5 days More

$675 USD in 15 days
(21 Reviews)
5.3
sunshine7677

Dear Client, I can build a Platform through VBA to facilitate the pick and pack process in the warehouse Let’s have a quick chat to discuss this project. Looking forward to hear from you soon. Regards, Ritika Kesh More

$400 USD in 4 days
(51 Reviews)
5.0
Sercho56

Hi, I am an Australian-based software developer with significant experience in Excel and VBA Programming. If you provide me a copy of your example Excel workbook, I can examine the data structure and design a simple More

$350 USD in 5 days
(20 Reviews)
5.2