Need help in splitting excel spreadsheet and export data to Word Document

[bigbug]

Hi there...

Im trying to acheive something in excel at work - and Ive been trying for the past 2 days with no positive outcome - can someone please help me or give me any advice?

So here is what Im trying to do. Ive attached 2 files. Trial.XLS and Trail.DOC.

1. Trail.XLS is the main host file. You can see columns with data in them. (Name, Title, Email and Identifier)
2. Identifier data is populated with either "T" or "F"
3. Everytime you see a "T" in Identifier, it means that its a new company. All the rows with the "F" identifier that follow the previous T belong to the same company.
4. I need to be able to split the table in excel whenever a "T" is encountered in the Identifier column - and then each split is exported into a Table in the Word doc.
5. Trail.xls is your before file, and Trial.doc is your After file. The end product should be what Trial.doc looks like. All the data is split up depending on the "T" identifier.

I hope I have explained that properly. Please let me know if you need me to clarify anything. Ive been trying/reading all sorts of Excel help/export stuff online, but cant find anything that benefits me - or maybe I just dont know. Im a noob when it comes to excel. Any feedback is truly appreciated