Hi All,
I am new to this forum and have a question for you experts in here.
I have two sheets in Excel that I am trying to work with. The sheet1 (FINISHED-PART) consists of part numbers of finished or packaged goods at my company. The sheet contains 4 different part numbers that each use 2 pieces of the same raw good. There are other bulk items in these finished parts that require them to have different part numbers.
FINISHED-PARTS.jpg
The sheet below (BULK-PART) is the one that contains the bulk part number that is consumed by all three of the finished part numbers above.
BULK-PART.jpg
Now trying to keep this simple and so it makes sense. What I am trying to do is SUM up the QTY AVAILABLE cell with the finished goods and have that total show in the QTY AVAILABLE cell on the bulk part sheet. The only things these parts have in common for sorting and adding is the the first 6 characters in the description in the bulk part field matches the first 6 characters in the NUM column in the finished part sheet. LOL! I hope you are following me?
Now, this is just one raw number and the 4 finished parts that consume it. We have hundreds of parts and I will apply the fix for this to the whole sheet if anybody is able to help with this. I just wanted to scale it down and see if you can do what I am asking.
Let me know if I need to provide more information?
Sincerely grateful for any help.
Bookmarks