+ Reply to Thread
Results 1 to 5 of 5

Remove 1 item Removes multiple lines (stock control) (BoM)

  1. #1
    Registered User
    Join Date
    01-07-2021
    Location
    manchester, england
    MS-Off Ver
    365
    Posts
    2

    Question Remove 1 item Removes multiple lines (stock control) (BoM)

    Hi,

    If I had a sheet that had components of a car with stock for example:
    Tyres 500
    Engine 300
    Chassis 250

    1 car equals 4 tyres, 1 engine, 1 chassis

    Is there a way I can:
    A) calculate how many cars I can make
    B) take 1 car out of stock (and it automatically remove the components from a separate sheet)?

    Apologies if this is tricky but im certain there must be a way.

    Thanks in advance
    Last edited by connorrr4; 01-07-2021 at 12:24 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,901

    Re: Remove 1 item Removes multiple lines (stock control) (BoM)

    Part 1:

    =MIN(B2/4,B3,B4)
    Attached Files Attached Files
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,901

    Re: Remove 1 item Removes multiple lines (stock control) (BoM)

    Part 2 depends on whether or not folow is one way only (± restocking of components).

    Something like this:

    =500-SUM(I:I)*C3

    or

    =500-SUM(I:I)*C12+SUMIF(L:L,A12,M:M)

    see sheet, as you need to see the context!!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-07-2021
    Location
    manchester, england
    MS-Off Ver
    365
    Posts
    2

    Re: Remove 1 item Removes multiple lines (stock control) (BoM)

    That is perfect, thank you

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,901

    Re: Remove 1 item Removes multiple lines (stock control) (BoM)

    You're welcome and thanks for the rep.

+ 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: 2
    Last Post: 12-11-2018, 07:46 AM
  2. Remove lines based on multiple criteria
    By cmray58 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-20-2018, 12:12 PM
  3. [SOLVED] Remove lines based on cell value (remove lines in range, not entire row)
    By Tapyr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-27-2015, 07:31 AM
  4. PLease Help: Dropdown list that removes previously selected item
    By Gus88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-01-2014, 01:28 PM
  5. [SOLVED] Stock Control - Alert user to low stock levels.
    By Kaies in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2013, 08:56 AM
  6. .CSV, remove multiple lines in one cell
    By christianlie in forum Excel General
    Replies: 1
    Last Post: 10-21-2011, 09:44 PM
  7. Stock control problem - multiple vlookups
    By theboywhelp in forum Excel General
    Replies: 2
    Last Post: 09-10-2008, 07:42 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