+ Reply to Thread
Results 1 to 3 of 3

Inventory Problem

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Ferrum, VA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Inventory Problem

    Hello
    I am working on an inventory project at school. I have calculated re order points for thousands of items in a warehouse. I want to be able to change the quantities for current inventory (column B in my attached example) and when the levels reach the re order point (column C in my attached example) I want excel to add those items to another sheet perhaps that list all items that have hit their re order point.
    Please let me know if you can help.
    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Inventory Problem

    Here is an explanation of what I didn:
    1. Column E in Sheet 1 determines if the Current Inventory is less than or equal to the re-order point, it is assigned a number (the max function finds the highest number already listed, and adds 1, giving each instance a unique #).
    2. In sheet 2, the Index and Match functions are used to return the list of items that need to be reordered. If you are unfamiliar with these functions, I suggest you do some reasearch. I'm happy to clarify anything if necessary.

    Is this what you are looking for?
    Attached Files Attached Files
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    04-17-2013
    Location
    Ferrum, VA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Inventory Problem

    Perfect, thanks a million

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1