Excel Sheet Customization for coordinating Shipments

I need a freelancer to build out an excel sheet that allows me to upload 10 or more different shipping plans into the document.

Those shipment plans each have a number of products going to different warehouses. The products in my inventory are mixed and going to different warehouses.

Each product has a custom barcode that is listed in each of the different shipping plans. I need the ability to pick up a random product, scan it, and then be told via excel which warehouse/shipping plan that it belongs too.

I have a version of this excel sheet that used to work, but somewhere along the way it got broken and stopped functioning properly.

This particular excel sheet allowed me to color each warehouse/shipping plan and give it a custom nickname. When the product was scanned it would display the color and name of the warehouse.

I need to be able to continually scan 500+ products. So the excel sheet needs to be able to scan the product, show me the color, and then prompt for the next scan.

After scanning a barcode the scanner gives the value of the barcode and a "return" or enter.

One initial challenge is that some shipments might have two of the same item, and those two items might be going to different warehouses. In this case I need the document to recognize that and give a quantity number per shipment.

I've attached the old excel sheet and 3 examples shipments. If you can please review these excel sheets and let me know the total cost to make it all functional and working again that would be great. When bidding please mention "coffee" in the beginning of your bid so that I know you understand and read through my text wall. I'm looking to have this ready within the next 4-6 hours max.

The barcode when scanned returns the value that starts with X########.

Skills: Data Processing, Excel, PHP, Software Architecture, Visual Basic

See more: free excel project management tracking templates, project tracking template excel free download, excel templates for business, multiple project tracking template excel, free blank spreadsheet templates, excel database template download, excel spreadsheet templates for tracking, excel task tracker template, excel sheet cities world, find entry excel sheet, excel sheet indian states cities, excel sheet marketing research survey data entry, data excel sheet macro, league soccer system excel sheet, populating excel sheet pdf survey, convert pdf data excel sheet, import excel sheet sql data base, view excel sheet form example net, creating standalone excel sheet, league fixture excel sheet

About the Employer:
( 8 reviews ) Vista, United States

Project ID: #18180024

9 freelancers are bidding on average $110 for this job


Hello, Hope you are doing well. I can help with you in your project Excel Sheet Customization for coordinating Shipments. I can assure you the quality job. I have good experience in Data Processing, Excel, PHP More

$100 USD in 2 days
(337 Reviews)

"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as More

$50 USD in 7 days
(18 Reviews)

Hello sir, I have 5+ year experienced Multiple project .I have good experience with deferent Task and I have been working for many years. I am a hard worker and enjoy working at all conditions. If hired More

$45 USD in 10 days
(6 Reviews)

"coffee" I can do what you need. I'm expert developing applications based in Excel and VBA. I have taken a look to your xlsm and tsv files and I'm convinced I can get it working. Please do not hesitate to contact me so More

$60 USD in 1 day
(3 Reviews)

coffee Hi i've experience in data processing with excel. I can fix that issue asap without affecting functionalities.

$50 USD in 0 days
(2 Reviews)

HI, coffee How are you? I am Rosy and I am Interested in your project I am highly expertise in Translate from English to Spanish Arabic to English and vice versa Article writer Video editor Business card maker, dat More

$45 USD in 10 days
(1 Review)
$45 USD in 10 days
(0 Reviews)

Dear Hiring Client, I have gone through your post and i understand your complete requirement on Excel Sheet Customization for coordinating Shipments. 1. I will create all functionalities of excel sheet 2. I will More

$40 USD in 10 days
(0 Reviews)

i can complete as soon as possible

$555 USD in 2 days
(0 Reviews)