Producing Packing Lists Based on PO List and Maximum Box Capacity

Đang Thực Hiện Đã đăng vào 3 năm trước Thanh toán khi bàn giao
Đang Thực Hiện

I have an order list of various products on various POs with different quantities by PO. I need to produce packing slips for a series of boxes for this shipment for the allocated quantities in column H.

The list is sorted by item number. Each box can fit 50 products. Any products that can not be fit in a box of a line item, that line item needs to be split and the remainder placed in the next box. We want to use the least amount of boxes possible. Item numbers will be repeated because they need to reference the PO number.

The goal is to have packing lists for each box of 50 and to have each qty of items for each PO to be clear. We want the quantities for each of the item numbers to be grouped together and to reference the POs they are on.

For reference:

[login to view URL]

Excel Excel Macros

ID dự án: #26872356

Về dự án

6 đề xuất Dự án từ xa 3 năm trước đang mở

Được trao cho:

daniyal3214

I can perfectly develop such a dynamic Excel based list. I am a professional Excel expert holding years of experience. I will be happy to discuss in detail how I am highly suitable for this project.

$15 USD / giờ
(76 Đánh Giá)
5.8

6 freelancer chào giá trung bình $19/giờ cho công việc này

asin1987

Dear Employer, I am an Excel expert and have been working on process automation projects since a decade now. Please consider me for this job, I will deliver a highly professional project. Please do check my previou Thêm

$20 USD / giờ
(201 Nhận xét)
7.8
MIGICI

Hello, I am a Finance & Accounting graduate and a CPA. I have seven years accounting work experience. I am well versed in Advanced Excel, QuickBooks Online & Desktop. I am driven, passionate and with great attention to Thêm

$15 USD / giờ
(6 Nhận xét)
2.9