Đã hoàn thành

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

Kĩ năng: Xử lí dữ liệu, Excel, PHP, Kiến trúc phần mềm, Visual Basic

Xem nhiều hơn: 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, getafreelancercom extract data website excel sheet, processing excel sheet javascript, store inventory excel sheet, macro specific items excel sheet income invoicc, stock items excel sheet excel, items stock excel sheet, excel sheet calendar items, products items add excel sheet

Về Bên Thuê:
( 8 nhận xét ) Vista, United States

ID dự án: #18179857

Được trao cho:

betatesting

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

$55 USD trong 1 ngày
(6 Đánh Giá)
3.0

9 freelancer đang chào giá trung bình $58 cho công việc này

Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Thêm

$65 USD trong 1 ngày
(177 Nhận xét)
6.6
usmanhassan123

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.

$65 USD trong 1 ngày
(49 Nhận xét)
5.9
SidhuDN

Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. My price is $60 Look forward to hearing from you soon. Thêm

$60 USD trong 1 ngày
(12 Nhận xét)
4.6
dalsaniyasonu123

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.

$70 USD trong 10 ngày
(15 Nhận xét)
3.6
dataexplorer

"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"

$50 USD trong 10 ngày
(16 Nhận xét)
3.5
ARahman93

Hello I have lots of experience in data typing, data entry, excel,web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant. I hope your kind resp Thêm

$40 USD trong 10 ngày
(0 Nhận xét)
0.0
quadrant04

i am Excel Vba and Excel Micros Expert i can handle your excel computting task also. I have i year of experience in this field. Tahnk you

$55 USD trong 10 ngày
(0 Nhận xét)
0.0
Intisam

i can do for this job

$61 USD trong 7 ngày
(0 Nhận xét)
0.0