Large CSV Data

[koh010]

I have a client data with full details in about 50 different csv files

e.g.
------------------------------------------------------------------------------------------------------------------
1 2 3 4 5 6 7 8
------------------------------------------------------------------------------------------------------------------
a1 b1 c1 d1 e1 f1 g1 h1
a2 b2 c2 d2 e2 f2 g2 h2
a3 b3 c3 d3 e3 f1 g3 h3
a4 b4 c4 d4 e4 f3 g4 h4
a5 b5 c5 d5 e5 f4 g5 h5

Column 6 contains the nature of business, so i want to EXTRACT ENTIRE Row according to the Colunm i.e EXTRACT all Rows that Contains f1 and copy to new book/sheet.

and then Extract all Rows that Contains f2 and copy to sperate sheet/workbook.

I have 50 CSV file and about 3000 different type of categories in Column 6 (in all 50 CSV)


So I need to sort that data in to separate sheet according to categories listed in Column 6.


Please suggest best possible and easiest way to perform this, its urgent.

I will be very thankful.

regards,

[TechRetard]

I have 50 CSV file and about 3000 different type of categories in Column 6 (in all 50 CSV)

So I need to sort that data in to separate sheet according to categories listed in Column 6.

to be clear...you want 3000 sheets?

[davesexcel]

Maybe post a very small example workbook so somebody has something to work with.