Split Worksheet to multiple workbooks

Hi all,

I haven't had to do much VBA code in excel and I now have a project where I need to do so. Here is my scenario:

I have a XLS file that contains a button that executes some VBA. The vba then opens another xls file containing the Data I need to split into multiple files.
Header row:
Policy # | CSV | Underlying CSV | Curr DB | GCR | COI | FEES | Bank Code | CARRIER SHORT NAME | Parent Company Short Name | Case Date

Data Rows:
0044562 | 1,034,312.14 | 1,572,154.45 | 3.85 | 769.52 | 5.25 | 91454 | ARAB | MASS | 09282001
0045644 | 312,198.80 | 615,031.64 4.15 | 150.99 | 5.25 | 91493 | ASSO| MASS | 06112001

Carrier Short Name, Parent Company Short Name and Case Date will essentially be the filters. So when those match they go to a file with the name of: ARAB_MASS09282001.xls which is those 3 columns. I'm having trouble being able to split the data based on 3 columns and save them to the new file name. Any help would be greatly appreciated. If you need any more info let me know.

Regards,

J

JB - I just got back from vacation so I am looking at this now. I will let you know how I fared. Thanks!