filter values copy and add row and insert

[gangadharan2k8]

1. In "sheet1". i have to columns "A" and "B".
2. In "sheet2" for "A" column value are there with blank cells
3. if i filter one "A" column Value in "sheet1"..there will be "n" number of result we are getting.
how can we get that all values under "sheet2" with insert rows?



[TABLE="width: 500"]
<TBODY>[TR]
[TD]sheet1"a"
[/TD]
[TD]sheet1"b"
[/TD]
[TD]sheet2"a"
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 201"]
<TBODY>[TR]
[TD]E4B5-F31148-BAW</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD]2CBLT
[/TD]
[TD]2CBLT
[/TD]
[/TR]
[TR]
[TD]E4B5-F31149-BAW</SPAN>
[/TD]
[TD][/TD]
[TD]E4B5-F31148-BAW</SPAN>
[/TD]
[/TR]
[TR]
[TD]E4B5-F31148-CAW</SPAN>
[/TD]
[TD][/TD]
[TD]E4B5-F31149-BAW</SPAN>
[/TD]
[/TR]
[TR]
[TD]E4B5-F31149-CAW</SPAN>
[/TD]
[TD][/TD]
[TD]E4B5-F31148-CAW</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]E4B5-F31149-CAW</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]