Question VBA script needed

[Thorwyn]

Hi,

I´ve got a little problem with Excel.

I have one large Excel sheet with lots of entries, and I want two things:

a. insert a page break after each stack of identical data in one column.

For example, column C contains the following data:

AAA
AAA
AAB
AAB
AAB
CCC
DDD

Now I want to insert a page break like that for the entire sheet:

AAA
AAA
----
AAB
AAB
AAB
----
CCC
----
DDD
----

b. I want to save identical stacks of data into a new Excel sheet.
Same example:

AAA
AAA
AAB
AAB
AAB
CCC
DDD

I want to have

AAA.xls (containint all AAA datasets)
AAB.xls
CCC.xls
DDD.xls

Any idea how to script that in vba?