1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. K

    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...
  13. 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...
  14. L

    Automatic counter based on changes to a cell (inventory usage tracking)

    I am a librarian interested in tracking book checkouts over time. I only need to track how often an item has been used, not when or by whom it was used. My library is too small to justify the purchase of an ILS (circulation software), so I am looking for a simpler solution using what I already...
  15. R

    Simple Scanned Inventory in Excel

    Hi, If this isn't appropriate, please forgive me and let me know. I have a small business and am looking for a simple solution to taking inventory at the end of my season. I would like to be able to scan barcodes to enter the info. I would also like to be able to scan an item 3 times, for...
  16. J

    Create poup on item in home inventory

    Hi there, I created an home inventory in excel. I would like a popup to display information about the item when i click on it. I know Microsoft access has a home inventory and when an item is clicked on an asset detail popup is created. Just wondering if i'm able to copy this form to excel or...
  17. A

    Dynamically Pulling Data between Worksheets

    Hello, I am trying to do a small pull of data between two worksheets but in an active manner, I'm hoping someone here might be able to figure this one out as I can't come up with a perfect solution. Sample Data on Worksheet1: On Worksheet2 I would like to pull anything that says 'Yes' in...
  18. I

    VBA to open a PDF in another location.

    Hi All I have the following code that searches a network folder for a PDF doc based on the number in a cell and opens it if one exists: Sub OpenPDF_3() Dim strPath As String Dim strFileName As String strPath = "\\\D$\Excel Dashboard\Inventory" If Right(strPath...
  19. Vincent Thank You

    If cell above it contains same data, change formula

    I've been stuck on this for about a week, I'll do my best to explain what I'm trying to do. I have column J with the following formula: =(((G2)+(F2/Q2))-(NETWORKDAYS(TODAY(), I2)/22)) I'm using this formula to tell, based on months of inventory on hand (G2), plus months on purchase order...
  20. H

    VBA List Data

    Hi all, I have a list of data: Apple 580 Pear 245 Orange 867 Cherry 870 etc. What I want to do is split my inventory between 5 locations randomly, but will only ever total the total inventory and then have VBA print the array so that it's like the following: Apple 156 Apple 142 Apple 52...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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