inventory

Hi good people. I need help calculating the Work In Progress (WIP) inventory for my work. My Excel spreadsheet has three columns. Column A is the item’s unique identification code Column B is the time that the item entered the warehouse Column C is the time that the item left the warehouse Is...

I want to make a program that tracks which station each of my projects is at using barcode scanners. My small business deals with putting certain lots through certain stations, kind of like an assembly line but the line is a snake that wraps around it self a couple times over and ties itself in...

Hi All, My husband struggles with Excel and finds G Sheets easier to work with. So this is my current situation. I am trying to create an inventory system of sorts. Overall I will not have more than 21 items but to create the final product I might need 3 items up to say 10 items. So what I was...

Looking for an if/then formula that includes a cascade effect. For example column A is pallets of beer, it holds 24 cases of 24 beers. Column b is cases (so when you open a pallet you then 24 cases) then column c has individual bottles. Once column C goes into the - (minus) I would like the...

Hi, I'm trying to create an Inventory Count Database in Excel using a Macro/VBA. The concept is for the Count Team to enter in an Item Number and Bin Number (which I have Data Validation on to prevent typos/errors). The Item Description is a formula that will pull the description associated...

Hi all, I have inventory stock details with 11,000 part count and I am making vehicle from this inventory. Now for one vehicle I require 1300 to 1500 parts with varying quantity on each part. there will be multiple vehicle codes I want to create a crisp VBA where it will show me 1) how many...

Hi all, I've just started a new job and I've been asked to calculate a reorder level for each item below . I've spent all day trying to google what how to do this but I'm having so much brain fog and can't seem to wrap my head around how to calculate it the correct way/find a formula that...

hello everyone i hope you are well, i made this file for my self with little knowledge of VBA and excel to be good at producing reports, that was until i discovered this place where people have done something amazing, ive been driving myself crazy for the past one week trying to find a way to...

So, I'm wanting to build a custom inventory spreadsheet to better track out material in house. We have a process to tracking our inventory, it being tracked in total square yards. We currently do our inventory the old fashion way, that being with our trusty pencil and paper, read all tags...

I created a report in Excel using PowerPivot that shows how many of each part number are needed each day to fulfill customer orders. To do this I pulled 2 tables from our ERP database. (The data below is simplified for this example but should convey what data is available.) 1st: The part table...

Hi all Regard to Calculating days of supply using DAX... thread I would like to ask you for help. I need to calculate Days of Cover. Data structure is following: WeekDate, Product, ClosingStock, Demand. I tried to use the code from previous thread but I hit on problems. First one is on the line...

I need to do inventory using a barcode scanner and excel. How do I make it so after I scan it the program will search the old inventory spreadsheet for the matching barcode and copy the barcode as well as the adjacent cells (with the item names and serial numbers) into the new spreadsheet. I...

I'd like to generate a function for a specific cell, where the amount increases or decreases, depending on what the user types into a specific cell - connected to two different buttons. Once clicked a button, the cellvalue needs to add/subtract from the original value, mounted in a separate...

Hello! I work with manufacturing security doors, and to make my life easier I wanted to create an excel chart with a table of materials in the inventory then subtract from them the materials I need for each type of door I am going to make. For example, let us say I made door1 and it requires X...

Hi all. Firstly im new here and English isnt my native tongue so I would like to apologize beforehand if my explanations aren't very clear. Truly appreciate if anyone can help me with the following: I generally have two sets of data: 1.First one is an inventory list of clothes with their...

Hello all, I'm trying to improve the inventory management process at work, currently we're tracking everything through manual input (handwritten) using a form and then we put any relevant information on a sticky note and post it to the box. These boxes come in from numerous different places and...

I've looked around here but couldn't find what I was looking for. I have a client who does inventory audits. He gets an inventory list in Excel the night before his count from the warehouse manager. These lists are formatted in all kinds of crazy ways so that night we reformat the list...

i started using excel at my current new employment. I got to say that i am quickly become a little obsessed in learning more! Right now i am creating an inventory list with shelves named by alphabet and number of shelves. ex: A1,A2,A3 and so on. Every letter has its own tab, containing the...

Hi, can any one help me with my office batch inventory solution in excel. Dispatch data is available and i need to summarize it in batch summary. Thanks a Lot.

Hello, I have the below listed formula that was created here for me, but I need to change it from looking at H8 or D8 to just look at the whole column for example just H or D and if it find it copy the date were it matches =IF(IFERROR(INDEX('Inventory Stats'!$H$8:$H$100,MATCH(D8,'Inventory...