Filtering in Excel Macro

[austinandrei]

Hi,
I have an excel data wherein there are list in Column A that needs to be filtered then copy in a new sheet.
It will start with the first item then all data will be copied to a new sheet then save to a folder and then the macro will go to the second item then all data will be copied to a another sheet and so on.
There is a limit to how many items the excel filter can show and this macro should take all values.

austin

 

[austinandrei]

Here's the sample file:

Serial Number	Item	Settled date	Pieces	Currency
899816	1	15-08-2014	100	USD
899688	2	15-08-2014	100	USD
899559	3	15-08-2014	100	USD
899559	4	15-08-2014	100	USD
899559	5	15-08-2014	100	USD
895704	15	15-08-2014	100	USD
895382	16	15-08-2014	100	USD
894952	17	15-08-2014	100	USD
892300	18	15-08-2014	100	USD
884900	19	15-08-2014	100	USD

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

First filter will be like this then copy all data and paste to the sheet next to it:

Serial Number	Item	Settled date	Pieces	Currency
884900	19	15-08-2014	100	USD

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

 

[austinandrei]

Hmm.. I think I know now how to get things done by using a separate sheet to list all unique data in Column A and use it as variant. Thanks