+ Reply to Thread
Results 1 to 2 of 2

Creating an automatic stock list/inventory, HELP!

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Creating an automatic stock list/inventory, HELP!

    Hi guys, basically i am creating an inventory where it simply says how much stock is remaining so I know when to re-order. At present i got a function added so that if a value of stock is 1 or below the rows will highlight.

    What I want to do is create another sheet where the information from the stock amount page automatically transfers into a clear page so that I can see what needs ordering.

    Im a newbie so all this is very confusing and I dont have a clue where to start for this particular thing.

    I have attached two pictures for you all to see. Any help will be greatly appreciated.

    Main page:
    http://s15.postimg.org/s3ku0snpn/excel1.png

    What needs ordering page:
    http://s16.postimg.org/oqec8db5h/excel2.png

  2. #2
    Forum Contributor
    Join Date
    04-13-2010
    Location
    England
    MS-Off Ver
    Office 2016 365
    Posts
    211

    Re: Creating an automatic stock list/inventory, HELP!

    A problem you've got is your data structure. By having a heading and then child rows, i see what you are trying to achieve, but it makes it difficult for Excel!

    If possible, have sheet 1 as a table proper where each row has a printer name. See the attached on how best to set out your source data...

    Then you can run a pivot table over the top of it with a filter for Stock 0, 1 then just right click and refresh, or refresh all from the Data tab.

    This method means you could also add extra columns to the source data for cost, or supplier name, lead times for orders then your summary page you could add more pivots to show different facets of your source data.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  2. Inventory counting by comparing stock barcodes against master barcodes list
    By jamiemacdonough in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2011, 04:51 PM
  3. Inventory Stock Balancing with Inventory Data
    By bingbangboom in forum Excel General
    Replies: 2
    Last Post: 01-30-2011, 11:06 PM
  4. Creating an automatic Check list of errors
    By Bada in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2009, 02:18 PM
  5. Creating a Dynamic Inventory List Based on Daily Sales
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 11:01 AM

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