pls help me....i am new to excel..this may be quite easy.

krishna334 · May 22, 2009

i am new to excel....pls help me...i am stuck up with a small problem...

suppose there is a component..say a connector which consists of 3 sub-parts too say A,B,C.

so if i need to use 2 nos of connectors for a machine...then we need to have
2 nos of the subparts A,B and C too along with the connector.
So if in one worksheet i give the quantity of connector to be 2 nos
then automatically the connector + the subparts A,B,C should
come in a new worksheet in consecutive rows with qty 2 nos in the corresponding adjacent column....
.....pls tell me if its possible with some built in functions without
any VBA coding.

sanrv1f · May 22, 2009

Hi and welcome to the board,

could you post some sample data with the expected results for better understanding the problem

krishna334 · May 22, 2009

thank u sankar....i will do it right now

krishna334 · May 22, 2009

MY PROBLEM IS LIKE
<table x:str="" style="border-collapse: collapse; width: 283pt;" width="377" border="0" cellpadding="0" cellspacing="0"><col style="width: 85pt;" width="113"><col style="width: 127pt;" width="169"><col style="width: 71pt;" width="95"><tr style="height: 46.5pt;" height="62"> <td class="xl28" style="height: 46.5pt; width: 85pt;" width="113" height="62">Z704</td> <td class="xl26" style="border-left: medium none; width: 127pt;" width="169">DT06-4S</td> <td class="xl27" style="border-left: medium none; width: 71pt;" x:num="" width="95">4</td> </tr></table>the above is just a row in my excel sheet...these are 3 datas in adjacent columns.

Z704 just a code for connector named DT06-4S and i need 4 ( quantity ) of them.

But DT06-4S has W4S and DT04-4P-EP13 to be added along with it that too with quantity 4 and this should come in a new excel workbook as below:

<table x:str="" style="border-collapse: collapse; width: 326pt;" width="434" border="0" cellpadding="0" cellspacing="0"><col style="width: 73pt;" width="97"> <col style="width: 174pt;" width="232"> <col style="width: 79pt;" width="105"> <tbody><tr style="height: 46.5pt;" height="62"> <td class="xl29" style="height: 46.5pt; width: 73pt;" width="97" height="62">Z704</td> <td class="xl26" style="border-left: medium none; width: 174pt;" width="232">DT06-4S</td> <td class="xl28" style="border-left: medium none; width: 79pt;" x:num="" width="105">4</td> </tr> <tr style="height: 46.5pt;" height="62"> <td class="xl29" style="height: 46.5pt;" height="62">Z704</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 174pt;" width="232">W4S</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" x:num="">4</td> </tr> <tr style="height: 46.5pt;" height="62"> <td class="xl29" style="height: 46.5pt;" height="62">Z704</td> <td class="xl27" style="border-top: medium none; border-left: medium none; width: 174pt;" width="232">DT04-4P-EP13</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" x:num="">4</td> </tr> </tbody></table> i dont know how to do that,,,,pls help

sanrv1f · May 22, 2009

First set up a master table of Parts along with their sub parts, like

<TABLE style="WIDTH: 382pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=509 border=0 x:str><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 4053" width=95><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 5546" width=130><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5930" width=139><COL style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 6186" width=145><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" width=95 height=19>

Part

</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 98pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=130>

Sub part1

</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 104pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=139>

Sub Part 2

</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 109pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=145>

Sub Part 3

</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" height=19>

Z704