summarizing the autofilter data

[skarthickbabu]

Dear Mr Excel,

Is there way to get the extract the data from the autofilter to another sheet dynamically?


The following is my data sheet:

my excel sheet has just two columns

Assignment code

[TABLE="width: 407"]
<colgroup><col><col></colgroup><tbody>[TR]
[TABLE="width: 407"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]AB 1234712822 ABC - ABC 200
[/TD]
[TD="align: right"]485190
[/TD]
[/TR]
[TR]
[TD]AB 1234712822 ABC - ABC 300
[/TD]
[TD="align: right"]485160
[/TD]
[/TR]
[TR]
[TD]AB 1234712822 ABC - ABC 200
[/TD]
[TD="align: right"]485120
[/TD]
[/TR]
[TR]
[TD]AB 1234712822 ABC - ABC 400
[/TD]
[TD="align: right"]485110
[/TD]
[/TR]
[TR]
[TD]AB 1234712822 ABC - ABC 300
[/TD]
[TD="align: right"]485130
[/TD]
[/TR]
</tbody>[/TABLE]
[/TR]
[TR]
[TD]such thisng goes on 100 rows.

when is use Autofilter in these two columns, i get what i want.

My questions is there an possibility to export the stuffs from the autofilter to another column.
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]so in the above example. i want the excel to filter stuffs and put it in another column.

esp wanted coulumn should like this

AB 1234712822 ABC - ABC 200
AB 1234712822 ABC - ABC 300
AB 1234712822 ABC - ABC 400
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Can somebody help me ?

Thanks for the support

regards
Karthick

[/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]