1. N

    am in going in the right direction using XLOOKUP

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

    If/then cascade effect for inventory spreadsheet.

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

    Help : Inventory Database

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

    comparing array - finding how many kits can be made from existing inventory

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

    Re order level

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

    Tracking inventory

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

    Custom Barcode Inventory System Using Excel

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

    Report Inventory needs to support customer order with flow through assembly tree when in excess of parent part stock available.

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

    Calculating days of supply using DAX...2

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

    Creating an automated inventory system using excell and a barcode scanner

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

    VBA Inventory

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

    Help with creating an inventory management for production purpose

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

    Raising or discounting the price of inventory against a curve that represents the average temperature in a certain area.

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

    Excel/Sheets - ISO Solution

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

    Inventory Add-On

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

    Clueless, inventory quick search

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

    Batch Inventory in excel

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

    Change Formula

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

    How do I take a total value and reduce the value of a cell and move to next until the total is met?

    It's difficult to describe, but could be considered something like a first in first out calculator. There must be an easier way to do this than manual subtraction. For this example the total inventory is 7500, I Would like to find how much was under 25, and if the total isn't met then move to...
  20. S

    How to get excel to accept input from a barcode scanner and add "+1" to a column

    Hey friends. Not sure if this can be done but here is what I want to accomplish. Our store's inventory will happen soon. Our old style of doing inventory is slow and I want to streamline this process. Our point of sale system allows me to export all of our inventory items, which includes the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back