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########.
Được trao cho:
Coffee , k sir ping me to discuss further on this and also I have questions about this. Regards. Relevant Skills and Experience PHP , excel , data processing , software architecture
9 freelancer đang chào giá trung bình $58 cho công việc này
PhD in computer science having seven years of experience in Excel development. sir I can update your Excel sheet I have seen the details and sir I can deliver you dynamic sheet. I already done many projects in Excel.
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
"Hi, I would love to help you in your Current Project and it would be with confidence and satisfying results. I'm look forward to hearing from you about the project. Best Regards"