+ Reply to Thread
Results 1 to 6 of 6

Inventory tracking formulas and formula for discounts or bulk buying

  1. #1
    Registered User
    Join Date
    10-16-2020
    Location
    Calgary, Alberta
    MS-Off Ver
    10
    Posts
    8

    Inventory tracking formulas and formula for discounts or bulk buying

    Hello i need some help with the inserted formulas, a couple features aren't working that were and i cant figure it out i have a master sheet in a workbook another sheet is sales and another is to add inventory. I had it that the master sheet would automatically update the stock level when an entry from sales or adding inventory was entered, and would update the stock accordingly. This is not working on one of the sheets and I'mhaving a hard time seeing where the issue is.
    Also when an inventory item is sold or added that the price is auto populated from the master sheet, this is no longer working.
    I would like enter a discount formula for bulk buying at a lower price and that the inventory would also be adjusted accordingly.

    Thank you for any help offered
    Attached Files Attached Files
    Last edited by kareylee; 11-07-2020 at 05:05 PM. Reason: more information in title thread

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Help with formula

    Title was changed by OP as requested Thanks
    Last edited by Pepe Le Mokko; 11-08-2020 at 03:53 AM.

  3. #3
    Registered User
    Join Date
    10-16-2020
    Location
    Calgary, Alberta
    MS-Off Ver
    10
    Posts
    8

    Re: Help with formula

    hi. Is the change ok

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Inventory tracking formulas and formula for discounts or bulk buying

    In my opinion it might be beneficial to look for ready made inventory templates such as the ones in the link below.
    https://templates.office.com/en-us/Inventories
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Inventory tracking formulas and formula for discounts or bulk buying

    Attached the basics of a VBA solution.
    I submitted this some time past on this forum.
    Simple to expand - all actions are within the code - no on sheet formulas required.
    It uses Tables-ListObjects - so literally self maintaining.
    If this approach is of interest post back on this site and will help to develop it further.
    torachan.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-16-2020
    Location
    Calgary, Alberta
    MS-Off Ver
    10
    Posts
    8

    Re: Inventory tracking formulas and formula for discounts or bulk buying

    Hi, I love this style, it actually could work great except i need to select a potential discount and display what the price would then be with the discount. and then have it reflect the cost. Question how would i be able to gather information about sales discounts etc in this style

+ 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: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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