Results 1 to 8 of 8

Bill of Material Data Look up issue

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Bill of Material Data Look up issue

    Greetings all,

    I have an inventory of several hundred raw material items. I have a sheet with all of the raw materials going down the left side and the finished goods going across the top with quantities required for each finished good making up the body of the data. These quantities are then summed to the right to give me my total material requirements.

    What I am attempting to do is to extract a concise bill of materials based on the finished good number. What I am afraid of is that I have wandered too far and have entered the realm of Access or some such.

    Suggestions? Solutions? Condolences?

    Thanks to all!
    Attached Files Attached Files
    Last edited by jacob@thepenpoint; 05-07-2013 at 10:09 AM.
    Jacob Albers
    Excel 2003 & 2010

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