Split Sheet

[u2moo]

Here is an example of the data I would like to manipulate:
Eg.
Column A Column B Column C
123456 test data1 Blah Blah
123456 test data2 Blah two
123456 test data3 blah three
453545 bb aa
678499 cc xx

I want to group the id's(column A data) and save only the data in rows 2 & 3 for each id to a new file. I would also like to save the new file with the name of the id, eg 123456.xls.

EG
File Name:123456.xls
Contents:
test data1 Blah Blah
test data2 Blah two
test data3 blah three

File Name:453545.xls
Contents:
bb aa

etc...


I look forward to your responses!



_________________
Aaron
This message was edited by u2moo on 2002-04-21 23:03
This message was edited by u2moo on 2002-04-21 23:08
This message was edited by u2moo on 2002-04-21 23:10