Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Weekly Stock Without Listing All Products Weekly

  1. #1
    Join Date
    13th June 2007
    Posts
    3

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th March 2007
    Posts
    128

    Re: Weekly Stock Without Listing All Products Weekly

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    13th June 2007
    Posts
    3

    Re: Weekly Stock Without Listing All Products Weekly

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

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    12th March 2007
    Posts
    128

    Re: Weekly Stock Without Listing All Products Weekly

    Only the Administrator can tell.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    19,749

    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.

  6. #6
    Join Date
    13th June 2007
    Posts
    3

    Re: Weekly Stock Without Listing All Products Weekly

    OK thanks for all your help.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Formula for weekly update
    By starmern in forum Excel General
    Replies: 2
    Last Post: May 5th, 2006, 16:39

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
  •  
porno