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

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.
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
Can somebody help me ? Thanks for the support regards Karthick

<colgroup><col><col></colgroup><tbody>

AB 1234712822 ABC - ABC 200	485190
AB 1234712822 ABC - ABC 300	485160
AB 1234712822 ABC - ABC 200	485120
AB 1234712822 ABC - ABC 400	485110
AB 1234712822 ABC - ABC 300	485130

<colgroup><col><col></colgroup><tbody>
</tbody>

</tbody>