Thorwyn
FH is my second home
- Joined
- Dec 22, 2003
- Messages
- 4,752
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?
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?