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><COLGROUP><COL></COLGROUP>[/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]