+ Reply to Thread
Results 1 to 2 of 2

Flagging an inventory item and moving it to next sheet, to pick the item from storage.

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    2

    Flagging an inventory item and moving it to next sheet, to pick the item from storage.

    Hello

    I am trying to make my life easier but I am stuck at this point. Basically I have an inventory list on sheet one. In that sheet there is a column that says that says "Pick Order". Now what I am trying to accomplish is that, if the "pick order" column has a value of 1 then that row gets copied to the second sheet which is "Inventory Pick List". This means that I need to move those items from storage to the store.

    Secondly, what I would like to do if possible is that on the "inventory pick list sheet”, there is a column that says 'picked yes or no”. This will have a value of 1 or 0. If picked = 1 then the column "quantity picked' from 'inventory pick list sheet" will be deducted from "QTY in hand' column of the inventory list.

    To make it short, when I am at the store I would like to mark 1 or 0 in the 'pick order' column. Then when I am at the storage I can look at the "inventory pick list sheet' and pick the inventory. When I mark it as 'picked yes or no' then it’s automatically subtracted from 'qty in hand' essentially updating the inventory in hand.

    I am still learning excel and I cannot believe how much potential this program has, I can do all this just with my phone and drop box and never have to worry about losing my data or paper lists!

    Thank you so much in advance.
    PS; attached is my current progress of the file.
    Jesse
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-08-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Flagging an inventory item and moving it to next sheet, to pick the item from storage.

    Ok, so after tinkering with it all night, I figured most of it out ( albeit a bit primitive).

    I have it set as, if pick order column is set to 1, then that brand and item description gets copied to the "inventory pick list" perfect. Then if quantity picked is 1,2,3 etc then net units on hand substracts the amount picked from inventory on hand. This gives me net inventory on hand. also good. Only thing I can't figure out is when I type Yes in the "picked yes or no" column, I need the net inventory to copy the data into "qty in hand" so that it updates current inventory after items have been picked.?

    Any ideas? Please help =) I am trying to learn.
    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. How to pick up only one/unique item/value from DB to Excel
    By anziga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2012, 05:09 AM
  2. Replies: 3
    Last Post: 11-27-2010, 02:54 PM
  3. Macro to pick up item from list
    By Saky in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-18-2010, 11:28 AM
  4. Deduct item from inventory worksheet
    By ChalkerL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2009, 03:21 AM
  5. [SOLVED] How do I build a excel sheet that counts item in an inventory
    By kenny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2006, 11:10 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