[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Cars[/TD]
[TD="width: 64"]TYPE[/TD]
[TD="width: 64"]MODEL[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h1[/TD]
[TD]I20[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h1[/TD]
[TD]I10[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h2[/TD]
[TD]I30[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h2[/TD]
[TD]I40[/TD]
[/TR]
[TR]
[TD]Suzuki[/TD]
[TD]S1[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD]Suzuki[/TD]
[TD]S2[/TD]
[TD]black[/TD]
[/TR]
[TR]
[TD]Suzuki[/TD]
[TD]S3[/TD]
[TD]PINK
[/TD]
[/TR]
</tbody>[/TABLE]
[FONT="]If I select Cars then it should show a unique identity like Hyundai and Suzuki.[/FONT]
[FONT="]And if i select Hyundai Then it should show Unique Type Like h1,h2 , likewise in Suzuki also s1,s2,s3[/FONT]
[FONT="]And in h1 (I20,I10), h2(I30,I40), S1(White), S2(black), S3(PINK)[/FONT]
[FONT="]The result should show on a different sheet.[/FONT]
[FONT="]Thanks in advance [/FONT]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Cars[/TD]
[TD="width: 64"]TYPE[/TD]
[TD="width: 64"]MODEL[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h1[/TD]
[TD]I20[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h1[/TD]
[TD]I10[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h2[/TD]
[TD]I30[/TD]
[/TR]
[TR]
[TD]Hyundai[/TD]
[TD]h2[/TD]
[TD]I40[/TD]
[/TR]
[TR]
[TD]Suzuki[/TD]
[TD]S1[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD]Suzuki[/TD]
[TD]S2[/TD]
[TD]black[/TD]
[/TR]
[TR]
[TD]Suzuki[/TD]
[TD]S3[/TD]
[TD]PINK
[/TD]
[/TR]
</tbody>[/TABLE]
[FONT="]If I select Cars then it should show a unique identity like Hyundai and Suzuki.[/FONT]
[FONT="]And if i select Hyundai Then it should show Unique Type Like h1,h2 , likewise in Suzuki also s1,s2,s3[/FONT]
[FONT="]And in h1 (I20,I10), h2(I30,I40), S1(White), S2(black), S3(PINK)[/FONT]
[FONT="]The result should show on a different sheet.[/FONT]
[FONT="]Thanks in advance [/FONT]