+ Reply to Thread
Results 1 to 1 of 1

Cross reference requiring a complex output

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    6

    Cross reference requiring a complex output

    Hi I am trying to help a friend of mine who is a planner by helping him to automate some of his work.

    He has a list of products with a list priorities that product can be made from. (see the first sheet attached- Green cells are the priority numbers)

    However not all the raw materials are available all the time when the product is required. (see the schedule sheet)

    The marco is then require to match the raw material based on priority to the product and carry over any surplus raw material over to the next time slot. (refer to the output Sheet)

    Then the raw material used needs to be recorded and the amount used, before matching the above loop for the next product.

    in total he has 55 bits of raw material and 500+ products

    Thanks for any help or advice.


    See the example attached.

    Question.xls
    Last edited by kosh; 10-07-2012 at 01:37 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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