Titles be split into different sheets

[wwballar42]

Hi,

Thanks for your time and help. I'm looking for a Macro that can help seperate several titles into seperate sheets. The data is coming from a text file and I was hoping if you guys could help me out. What I am looking for is seperating the titles into seperate sheets and keeping all their info. The one interesting thing about this is that the file I receive will display the same title multiple times. For example, the first title may be Program Properties Table Reports, and it will then display information below it, then it will say Program Properties Table Reports and display information below. This will continue until the next title, RACF Authorized Caller Table Report. This will continue for all the titles. I was hoping you can seperate the different titles into different sheets.
So the titles that are in the file:
1) Program Properties Table Reports
2) RACF Authorized Caller Table Report
3) RACF Exits Report
4) Selected User Attribute Report
5) RACF Started Procedures Table Report
6) RACF Class Descriptor Table Report
7) RACF Global Access Table Report
8) RACF Group Tree Report
9) Selected Data Sets Report

So there should be a total of 9 sheets.
Thanks for your help and let me know if you have any questions.
Attachment 328955

[patel45]

attach please the desired output