warehouse

Hi - I am trying to work out how I can get an average dwell time for product which comes in intermittently and gets despatched intermittently. a screenshot of the file is attached. As you can see, some products come in and then get despatched piece-meal whereby some will come in and hang...

Hi all, We have a tracker for stock waiting to be booked in. When our warehouse has booked in the stock, they enter 'Closed' into a particular cell, add a comment, and the line turns blue. How can I set the spreadsheet up so when the warehouse enter 'Closed', an email is created with the...

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

Morning from everybody! I have an electronic requisition DB that the production department uses to enter the parts needed on the shop floor. Warehouse people then print the req and take the parts down. This DB is open 24/7/365 I need to limit the time that production folks can issue new reqs to...

Hello, I want to build a simple sheet to manage inventory for rental business with 3 warehouses. Items can be pulled from, and return to any warehouse. When the quantity of items is entered, I want some kind of button to appear where I can choose which warehouse the items will pull from...

I've got a spreadsheet with nearly a million rows, I've included a snippet below. Each SKU should have the same cost regardless of warehouse. Also, each SKU should have the same cost multiplier regardless of warehouse. I need to find SKU's which do not abide by this. So, SKU 1343qq1 should be...

Hi folks im really new to excel & wondered if someone would help me with a formula exampled below im trying to find "sales order" on sheet 2 within "order number" in sheet 1 IF warehouse error equals True display username, im asuming this is a vlookup formula but i cannot get it to work with...

Please can someone help me with this formula issue - =SUMPRODUCT((Table2[Department]=[@Department])*(Months=[@Month])*(Table2[[Month 1]:[Month 12]])) Notes - 1) The Second Array is the Month dates which are outside and above data table 2. 2) The Third array is the 36 cells of data. 3) The...

Hi everyone it is my first thread on this site I am stuck with an issue and I hope you can help here is the file attached basically it's about stocking products between 3 warehouses. warehouse1 warehouse2 warehouse3 stock of 42 references each warehouse contains rooms in which there must...

I have a table with Months across the columns and warehouse and items down the rows. I am trying to automate an upload file and need it in a format with warehouse, item, Month and quantity...is there a way to do that with a pivot table? See simplified example below... Table looks like this...

Hello, I have to return a warehouse location from one column or the one next to it. Think in terms of "virtual" warehouses (the locations in the system): You might have 2 virtual warehouses...A&B for the sake of simplicity. Warehouse A might house product A, OR, it might be in Warehouse B...

Hi folks, I'm trying to add up the figures from a data dump that are a certain Brand, Warehouse, and Receipt Month. I know my arrays named Brand, Warehouse, Receipt Month and Rec Units are all the correct matching sizes. Any idea why this formula returns "#VALUE!" ...

trying to use the smart complete to create a range of warehouse locations. here is a sample below. with a max of the last decimal of 3. Thanks! <tbody> 011.001.001 011.001.002 011.001.003 011.002.001 011.002.002 011.002.003 011.003.001 </tbody>

Hello, There is a warehouse with products. Every product consists of boxes with different weight. Every time a box from a warehouse goes to the shop it should be highlighted. So if the same weight from the warehouse is entered in the shop area, they both should be highlighted. But sometimes...

Hi I've just become a member of this site so if I do something wrong please dont jump too hard on me.:biggrin: I have a spreadsheet which brings data from another workbook depending on the criteria specified. E T U V Area Month YR...

I have sheet as below where "Items" in col A exists in multiple warehouse Col B and there value shown in Col D. I need a formula on another sheet to sum "Item value" irrespective of Warehouse. Vlookup or Index stops on first instance and ignores the rest of the table. <tbody> Item WH Inv...

Hi All, I hope someone can help me how to use the vlookup to find data in a set of range that may change. Sheet 1 is the place where I need to find qty of each item in each warehouse. Sheet 2 is the data that will be downloaded from database. I can use vlookup to find the qty of each item in...

:laugh: I’m trying to keep up with the amount of days my warehousestores tires. I already fill out a un-load and store form with a date for theinbound tires. I copy that date to my warehouse sheet as follows: = 'Inbound TU '!$H$1 This puts date in a blank cell on my warehouse sheet. This checks...

I have a formula that indexes well but I need to take it to another level I have attached a link to the actual file What I would like to see happen is under the warehouse tab B3 that index formula works well but what I need to take it further is that the data its looking for right now looks...

Hi guys, I have an excel file with inventory availability in 4 different warehouses: <tbody> warehouse 1 warehouse 2 warehouse 3 warehouse 4 Y Y Y Y Y N Y N N N N N N N N Y </tbody> Y means that there is inventory in stock, N means that there is none. How do I...