Template_1105.xlsx
1. I need Help trying to move the Bulk orders of the cookies over to the 1k pack size, while keeping in mind, they have to match the code/date and add to the numbers in the same row's orders.
ex:For the first bulk amount on 1/1/2014; it is showing 5 orders, so I need to move the 5 orders over to the 1k orders and add them together (5+15), the total combined amount going in the 1k order cell (=20). The Date(1/1/2014) has to match as well as the code, the materials don't matter in this part
2. I also need to move the Ready Stages orders and add them to the processing stage's orders while keeping the same pack size/code/date all the same.
ex: This next part is moving(adding) the "order"(order column) amounts of the "ready stages"(stage column) over to the "Processing stage"(stage column) (have to share same date/code type/Pack size)
This is for a large amount of data that would take too long to do by hand. I would appreciate any help to make the process faster, Thanks!
P.S The bulk orders are counted in thousands (1k) but still have no pack size.
Bookmarks