pallet

Hi All. I have just been sorting out an excel file for the warehouse locations for pallet spaces. What I was trying to do was if a was in a space I could either use an EU for euro pallet or UK for a UK pallet which are bigger than the Euro pallet it would turn Red to say there was a pallet there...

Hi, I'm struggling to come up with an IF formula that works (If that's the right formula to even use), and I need an expert to point me in the right direction. I'm trying to come up with an price calculator that will calculate a pallet rate or a lift rate depending on the cubic volume or the...

<tbody> column/row A B C D 1 Item Unit or pallet unit per case Total Case 2 Apple 50 2 25 (=50/2) 3 Apple on a pallet 4 2 8 (=4*2) 4 Orange 8 4 2 (=8/4) 5 Orange on a pallet 15 4 60 (=15*4) </tbody> I want to use if formula to calculate for column D. what should the formula be? I...

Good Afternoon, Please note I'm very new to Excel..! I have to create a master spread sheet that records the pallet number, the project names that are on each pallet and the serial numbers of the items that belong to each project. I'm using column A to record pallet numbers. Pallet 1,2,3 etc...

Hi, I cannot seem to get all parts of my formula to calculate. I have created the formula for 243 rows, but even though the formula is supposed to calculate correctly for all rows, it seems to work for some rows but not for the rest where it is supposed to calculate. My formula is as...

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

Good day Excel Guru's I have been trying to achieve the following with no success, I have tried using SUMIF with SUMPRODUCT but I have not been successful. I would greatly appreciate any guidance on the problem I am trying to solve. In Summary I am trying to workout number of boxes per pallet...

Afternoon All, i'm after some help in emailing a range of cells depending on which cell changes to "on suspect list" See example below. A B C D <colgroup><col...

I have two spreadsheets spreadsheet 1 is cost1, spreadsheet 2 is cost2 In cost2 cell4 I need to evaluate the cost of an item. the cost of that item changes in relation to the amount shipped. The values of these items are in spreadsheet cost1 cells C28-L28 If I ship 1 pallet of 720 items the...

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

Hello - I'm working on a new project where a client is wanting a spreadsheet to track where products are staged in their warehouse. They keep pallets staged as "inventory markers" for a different products. Their concept is to enter a pallet number ("Pallet 001") in their Excel database...

I have a project where I need a cell to auto increment by one every 4th printed page. It would look like this. Page 1 - Pallet 1 of 100 Page 2 - Pallet 1 of 100 Page 3 - Pallet 1 of 100 Page 4 - Pallet 1 of 100 Page 5 - Pallet 2 of 100 etc... What would I need to do to accomplish this? Thanks

Hi all. Just joined and would like to know if anyone could please answer a query I have. I have a sheet with multiple pallet codes in column A as in the example below. One pallet number could contain up to 500 items which can all be different. 123456 123456 123456 111222 111222 222112 222112...

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

Hello, Good evening, I need your help to get a solution for my question, I made a pallet label with an excel sheet, the value of the cell (A15) contains the value of the pallet ID (For example: PID00521), the cell (A17) contains the barcode of (A15). I want to make the value of the pallet ID...

Hi, I work in Logistics and at my company we have a hard time estimating the number of trucks that we are going to ship out of a warehouse. We have the item dimensions for each product that we ship and we know that we can fit 26 pallets onto a truck. However, we don't know how many items we can...