+ Reply to Thread
Results 1 to 8 of 8

Inventory Data Filtering

  1. #1
    Registered User
    Join Date
    10-08-2018
    Location
    Nevada
    MS-Off Ver
    10
    Posts
    4

    Inventory Data Filtering

    So I am attempting to have my inventory on one page

    Example

    Name: Color: Size: Quantity to stock: 1
    Name: Color: Size: Quantity to stock: 0

    When one of them comes up with anything between 1-3 I want it to filter out onto another page so I know these are the only items that need to be stocked. So I want it to leave the ones that say 0 off the new page and only bring over what has to be stocked. What formula/function would I use to make this possible across multiple sheets to one sheet that it puts all the stocking data in. I need it to specifically bring over all the information size name color and how many to stock without bringing over the ones that do not require to be stocked. Whats my best route for this?

    Example

    Stock these

    Name Color Size Quantity to stock 1
    Name Color Size Quantity to stock 2
    Name Color Size Quantity to stock 3

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,429

    Re: Inventory Data Filtering

    .
    Paste in Sheet module :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-08-2018
    Location
    Nevada
    MS-Off Ver
    10
    Posts
    4

    Re: Inventory Data Filtering

    I wish I could post mine as an attachment but for some reason it wont allow me to do that. This is basically what im looking for but I have it over such a large amount of sheets with more to come. Im not particularly familure with where I put that code. Oh I see where I put the code now but how do I get this over multiple tables so on and so fourth maybe I can send a picture of what I have

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,429

    Re: Inventory Data Filtering

    .
    Paste this in the ThisWorkbook Module :

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-08-2018
    Location
    Nevada
    MS-Off Ver
    10
    Posts
    4

    Re: Inventory Data Filtering

    This is what im working with the one I want to restock on is named Restock. Does the fact that I have them set up as tables change anything? Also each one has two tables one for Tshirts the other for tanks.
    Untitled.png
    Last edited by Brian5591; 10-14-2018 at 05:47 PM.

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,429

    Re: Inventory Data Filtering

    .
    If is a true Table, it may pose an issue. My example tested here was not using Tables.
    (Note: by True Table, I mean going to the INSERT TAB, and selecting INSERT TABLE).

    You are tracking your inventory in Column G ... so you'll need the macro edited slightly to this :

    Please Login or Register  to view this content.
    and again ... this is copying the identified rows to a sheet named "To Order". If you want the sheet named something else,
    edit the sheet name in the macro from Sheets("To Order") to Sheets("Your New Sheet Name Here")

  7. #7
    Registered User
    Join Date
    10-08-2018
    Location
    Nevada
    MS-Off Ver
    10
    Posts
    4

    Re: Inventory Data Filtering

    Pretty sure its a true table how do I make it not one without deleting all my data
    Tshirt Count.xlsx

  8. #8
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,429

    Re: Inventory Data Filtering

    .
    I've removed the tables for you.

    I noticed on some sheets, you have duplicated the data in approx rows 2 - 20 by repeating the same in rows below. Keep in mind, anything you enter in Column G, regardless of row location,
    will be transferred to the RESTOCK sheet. If you are duplicating the data from the top rows to rows below ... your Restock numbers will be skewed.

    Also note that manual input of data on the Restock sheet should not be done. A notice is placed on the Restock sheet as a reminder.

    The macro also requires Column A on all sheets (except Restock sheet) to have an ITEM ID number. If there is a chance an entry may not have an ITEM ID number, we need to
    edit the code.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Logit; 10-14-2018 at 11:08 PM.

+ 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: 0
    Last Post: 09-04-2018, 02:52 AM
  2. [SOLVED] Need Help with Inventory Sheet: Adding to the inventory and Logging
    By petg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2015, 02:26 PM
  3. [SOLVED] Need help filtering data by filtering based on the last digit of a column/true statement
    By Stephen R in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 07:43 AM
  4. Want to set Week End Inventory #s to load in Opening Inventory
    By tkeat1692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2013, 11:24 PM
  5. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  6. Replies: 8
    Last Post: 11-16-2012, 01:24 AM
  7. Inventory Stock Balancing with Inventory Data
    By bingbangboom in forum Excel General
    Replies: 2
    Last Post: 01-30-2011, 11:06 PM

Tags for this Thread

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