I would like to run through a list of values in a column and perform calculations in a different column. It is tricky because the macro has to identify the text and correctly understand the data structure.
Please find my data set in the attached file.
The structure of the data is as follows:
the Final good is made up of Semis and Raws. Semis can be composed of Semis or Raws. Basically distinguishes between how complex the material is. For example:
In this logical order, the two Raws in the 4th and 5th row make up the Semi in row 3; the Semi in row 3 and the Semi in row 6 make up the Semi in row 2; and finally, the semi in row 2 and row 6 make up the Final in row 1.
I hope this question is clear so please let me know if it does not.
I want to be able to determine how much quantity of each Raw material is needed to make a Final product.
I've tried nesting some for loops and do/while loops but i am having trouble identifying identifying the different texts.