Zamknięty

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########.

Umiejętności: Przetwarzanie danych, Excel, PHP, Architektura oprogramowania, Visual Basic

Zobacz więcej: 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

O pracodawcy:
( 8 ocen ) Vista, United States

Numer ID Projektu: #18180024

10 freelancerów złożyło ofertę na kwotę $104 do tego projektu

schoudhary1553

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 Więcej

$100 USD w ciągu 2 dni
(328 Oceny)
7.7
dataexplorer

"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 Więcej

$50 USD w ciągu 7 dni
(16 Oceny)
3.5
CronyTech

"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 Więcej

$60 USD w ciągu 1 dnia
(2 Oceny)
2.4
Pdharmendra123

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 Więcej

$45 USD w ciągu 10 dni
(4 Oceny)
2.3
JayThaker

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

$50 USD w ciągu 0 dni
(2 Oceny)
1.4
sairasdq827

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 Więcej

$45 USD w ciągu 10 dni
(1 Ocena)
0.0
$45 USD w ciągu 10 dni
(0 Oceny)
0.0
aadisingh

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 Więcej

$40 USD w ciągu 10 dni
(0 Oceny)
0.0
ageorgeionut

Hi mister, I'm a experienced vba developer in excel and acces . I can help you with your project. Best Regards,

$45 USD w ciągu 10 dni
(0 Oceny)
0.0
kavithakavi2009

i can complete as soon as possible

$555 USD w ciągu 2 dni
(0 Oceny)
0.0