Announcement

Collapse
No announcement yet.

Weekly Stock Without Listing All Products Weekly

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Weekly Stock Without Listing All Products Weekly

    In the attached workbook, the CASTINGS worksheet has a SOH (stock on hand) column.
    It looks up the SOH from the SOH worksheet (column 3) for each product on order for that week.
    But how do I make week 2 use the SOH figure minus the previous weeks order, IF there was an order?
    And so on until week 52.

    The problem I have found is what if that product wasnt ordered for the last 4 weeks? Maybe I need a temp worksheet with all the products listed for all the weeks and a running total of SOH weather it is ordered or not?
    Attached Files

  • #2
    Re: Weekly Stock Without Listing All Products Weekly

    Cross posted
    http://<br /> http://www.excelforum...t=604135<br />

    Comment


    • #3
      Re: Weekly Stock Without Listing All Products Weekly

      Originally posted by sujittalukder
      OK I deleted the old post on the other site, is that ok now?

      Comment


      • #4
        Re: Weekly Stock Without Listing All Products Weekly

        Only the Administrator can tell.

        Comment


        • #5
          Re: Weekly Stock Without Listing All Products Weekly

          If you read the rules properly you will see that we do not expect you to place a link to any other posts on different forums. This is so on the other Forums.
          Hope that Helps

          Roy

          New users should read the Forum Rules before posting

          For free Excel tools & articles visit my web site

          If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

          RoyUK's Web Site

          royUK's Database Form

          Where to paste code from the Forum

          About me.

          Comment


          • #6
            Re: Weekly Stock Without Listing All Products Weekly

            OK thanks for all your help.

            Comment

            Working...
            X