Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / 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.

    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
    17,432

    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

    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

    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 HELP
    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