+ Reply to Thread
Results 1 to 6 of 6

Need Help with Inventory Sheet: Adding to the inventory and Logging

  1. #1
    Registered User
    Join Date
    07-24-2015
    Location
    Here
    MS-Off Ver
    2011
    Posts
    11

    Need Help with Inventory Sheet: Adding to the inventory and Logging

    Hey Everyone !

    I have a request and would appreciate it if you could help me out ! So I have an excel sheet which manages my inventory. So far it allows me to add items and remove items in the first sheet.

    For instance if you click on the manage inventory button and choose to Add/Update records, if something exists it brings up the description and gives you a quantity. You can change the quantity (If you take out of inventory). So if you change the quantity to something less than it already was and press the button it will get a message telling you that you are subtracting whatever the difference is. So if the amount was 500 and you can change it to 400, you get a message box saying you are subtracting 100 and when you click update, the quantity it will change to 400 and on the second sheet you will see a log of the Description, quantity removed, the date and time it was removed.


    So my request is now that it logs the quantity removed I want it to also log the amount that is added. So if the amount was 400 and I change it to 500, I want it to give me a message saying you are Adding 100 and when you click the update, the quantity will change to 500 and on the second sheet you will see a log of the Description, quantity added, the date and time it was added.

    Thanks in advance !
    InventoryManagementExcelfile.xlsm

  2. #2
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: Need Help with Inventory Sheet: Adding to the inventory and Logging

    Where you have this code:

    Please Login or Register  to view this content.
    Couldn't you add this?

    Please Login or Register  to view this content.
    You have a circular reference in your formula in col L btw.

    If this has helped you, please consider adding to my reputation by clicking the star on the left

  3. #3
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Need Help with Inventory Sheet: Adding to the inventory and Logging

    Maym,
    Thanks for the update
    I however noticed that on while adding to the quantity, the report on sheet 2 shows negative value, i.e "-", instead of a positive to signify addition to the database.
    i have however modified it that line of code and I think it works.
    Thanks all, I love this Forum.

    Please Login or Register  to view this content.
    Last edited by fortknox; 09-04-2015 at 02:36 AM. Reason: To highlight code

  4. #4
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: Need Help with Inventory Sheet: Adding to the inventory and Logging

    Good pickup Nice to see it worked for you.

  5. #5
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: Need Help with Inventory Sheet: Adding to the inventory and Logging

    Good pickup Nice to see it worked for you.

    If this has helped you, please consider adding to my reputation by clicking the star on the left

  6. #6
    Registered User
    Join Date
    07-24-2015
    Location
    Here
    MS-Off Ver
    2011
    Posts
    11

    Re: Need Help with Inventory Sheet: Adding to the inventory and Logging

    You guys are great, Thank you !

+ 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. [SOLVED] Need Help with making Inventory Sheet: Removing items and logging the date
    By petg in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-02-2015, 05:22 PM
  2. Want to set Week End Inventory #s to load in Opening Inventory
    By tkeat1692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2013, 08:58 PM
  3. [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
  4. Inventory Age Formula Needed for FIFO Inventory
    By SWeisser in forum Excel General
    Replies: 0
    Last Post: 07-20-2012, 02:44 PM
  5. Inventory Stock Balancing with Inventory Data
    By bingbangboom in forum Excel General
    Replies: 2
    Last Post: 01-30-2011, 11:06 PM
  6. FIFO Inventory- COGS & Inventory Valuation
    By aromaveda in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-24-2009, 02:05 AM
  7. Replies: 0
    Last Post: 10-04-2005, 08:05 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