Macro for Filtering

Hi,

I have some data like this..........

S.No-ID-Name of the Product-Name of the person-Amount
1-456-ERC-jon-6564
2-645-FGD-gibbs-2231
3-458-GDF-jon-4534
4-456-ERC-jon-556
5-562-HUY-sam-215
6-645-FGD-gibbs-2231
7-458-GDF-jon-4534
8-456-ERC-jon-556
9-562-HUY-sam-215
10-458-SED-jon-556
11-254-ASW-sam-215
12-457-QWE-gibbs-2231
13-456-ERC-jon-4534
8-456-ERC--jon-556
9-562-HUY-sam-215

I have to import the data into excel through "-" delimited text to column.

Now i have to create a seperate work book for each Person in which i need to get the rows according to the ID speartely in a new sheet.
(like all the 456 code rows of that person in a new sheet in his work book and so on)

Can you create a macro where it first filters the name in the list(it should not take the name as criteria since the names would not be same every time)
Then filter each code and copy them to a new sheet for that person workbook and the next code of the list into the next sheet in the same work book and so on.

Practically I got some 60k every month and i need to do this.....

A macro would help me a lot.



Thanks,
Sam.

Originally Posted by royUK

If you want a macro to do this, see the code that I posted here

http://www.excelforum.com/showthread...advancedfilter

hi,

I need all the duplicates as well cause i will have a column for date as well
it gives the date of the transaction