Create two files depending on data

Hi,

I have an excel spreadsheet that I would like to create two different dat files from depending on what is in the Reversal column. Also before outputting to the dat file I would like it to resize the columns.

Here is what the spreadsheet currently looks like:

| student ID | Amount | Fund ID | Descr | Transaction Date | Term | Reversal |
| 1234567 | 866.00 | 9530 | FA16 | 20160531 | 5510 | Y |
| 1234567 | 866.00 | 9530 | FA16 | 20160531 | 5602 | Y |
| 1234567 | 1256.5 | 9330 | FA16 | 20160531 | 5602 | Y |
| 1234567 | 615.5 | 9330 | FA16 | 20160531 | 5602 | N |
| 1122333 | 1366 | 9630 | FA16 | 20160531 | 5510 | Y |
| 1122333 | 826 | 9630 | FA16 | 20160531 | 5510 | N |
| 1122333 | 1366 | 9630 | FA16 | 20160531 | 5602 | Y |

After the split to two DAT files (and deleting the header row):

DisbNeg.dat would have this in the file:

| 1234567 | 866.00 | 9530 | FA16 | 20160531 | 5510 | Y |
| 1234567 | 866.00 | 9530 | FA16 | 20160531 | 5602 | Y |
| 1234567 | 1256.5 | 9330 | FA16 | 20160531 | 5602 | Y |
| 1122333 | 1366 | 9630 | FA16 | 20160531 | 5510 | Y |
| 1122333 | 1366 | 9630 | FA16 | 20160531 | 5602 | Y |

DisbPos.dat would have this in the file:

| 1234567 | 615.5 | 9330 | FA16 | 20160531 | 5602 | N |
| 1122333 | 826 | 9630 | FA16 | 20160531 | 5510 | N |

This is great! Thanks! Is there a way to split onto separate worksheets within the same workbook? If I can get them on separate worksheets I can figure out setting the column widths.