+ Reply to Thread
Results 1 to 2 of 2

Inventory Sheets

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    Somewhere, US
    MS-Off Ver
    Excel 2007
    Posts
    1

    Inventory Sheets

    I am a newbie here and with vba. If anyone could give some guidance, I would be very appreciative. I am looking to create and Excel file with 3 sheets, Check-In, Check-Out, and Master List. Check-In and Check-Out would be where new items are logged in or out. Once an item is logged in, I want it to auto-populate in the Master List sheet as well as summed if it is an item type that has been previously received. When an item is checked-out I want it to be subtracted from the Master List. If there is no item to check out, or if it is getting low, to spit out a warning.

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,344

    Re: Inventory Sheets

    unless you have a large number of skus to deal with, you are better served to just do inbound and outbound on the same sheet and have the summary on other sheet
    then have running total without the need of VBA
    attached a very simple version of this

    The warning system can quite easy to implement, becomes rather complex if you have to deal with Maximum/Minimum inventory and lead times to deal with
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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