nitika.manhas
Member
For example- 614S090U01 is a Spare part kit, this kit has multiple items/components in it as shown below-
First screenshot I have number of kits sold in last three years, on separate sheet I have list of components in each kit, I want to add the components break down to the first screenshot sheet, how can I achieve it when the same component is used in more than one kit, for example, R-811 is used in '614S090U01 and '614S092U01, Please help! I have attached excel for your convince
View attachment 52970
First screenshot I have number of kits sold in last three years, on separate sheet I have list of components in each kit, I want to add the components break down to the first screenshot sheet, how can I achieve it when the same component is used in more than one kit, for example, R-811 is used in '614S090U01 and '614S092U01, Please help! I have attached excel for your convince
View attachment 52970