pallets

Hi Everyone, I need some help automating an excel sheet I use at work. None of the "Excel Experts" at work can tell me how to do this. I'm not sure if it's even possible to do what I want to do. So we use this excel sheet to calculate shipping, the shipping rates are based off of where the load...

Hi, Can someone help with the below formula? Thanks <tbody> If less than 42 carton = 1 and divide greater than 42 carton, divide by 42 to get number of pallets required. Cartons Per Pallet #FFE699[/URL] , align: center"]42 Less than 42 #FFE699[/URL] , align...

Hello All, I am looking to create a macro that runs through a list of part numbers. Some of these part numbers are pallets that contain certain end items. I need to write a macro that identifies these pallets, and creates separate line items for each component of the pallet, then deletes the...

Hi, New to the forum as I have a problem with a work sheet that has been bugging me all day. For example I want cell H5 to return the number of pallets it would require depending on the number of cases (I5) We can fit 126 cases onto a pallet so if I5 is between 1 and 126 then H4 should...

Dear all, I am struggling with a case, where I need to re-arrange a lot of numbers automatically based on certain criterias. For example: We have orders (always with numbers 123..) that are differentiated between 1. Country -at the end of the order is the destination U stands for USA D stands...

Dear all, I am struggling with a case, where I need to re-arrange a lot of numbers automatically based on certain criterias. For example: We have orders (always with numbers 123..) that are differentiated between 1. Country -at the end of the order is the destination U stands for USA D stands...

Hi All, I have a problem I could use some help with. I am trying to divide sales orders into pallets and haven’t been able to figure this out. I have a decent amount of experience with Excel, but I am by no means an expert. Our company produces 10 different products that we ship out...