How Do I Parse Contents of a Worksheet into Multiple Output Files

See more:

Perl

macros

I'm trying to separate the contents of an excel worksheet into several files for easier processing. What I have is a worksheet with information in several columns. The output files need to have contents of say:

1st file) Columns A + B + C + D
2nd file) Columns A + E + F + G
3rd file) Columns A + H + I + J

Column A information need to be attached to this grouping or output files all the time..Really appreciate all your inputs on this