Hi there, I have a huge Word doc that has a ton of good data in it in a totally non-consumable format. Essentially, it is formatted like this:

(Page 1)
Name: Jon Doe
Title: ....
Tel: ....
etc.

Percentage of revenue:
- % Texas: 30%
- % California: 20%
- % New York: 0%
- % Colorado: 50%

(Page 2)
Name: Billy John Boy
Title: ....
Tel: ....
etc.

Percentage of revenue:
- % Texas: 0%
- % California: 35%
- % New York: 20%
- % Colorado: 45%
I already have all the names in a table that can be easily copied into Excel. I'd like to create an Excel doc like the following (sorry, I tried to post this as an attachment but something wasn't working right for me...):
Name...............% Texas % California % New York % Colorado
Jon Doe
Billy John Boy

I'd really like to get a macro that can go and fill in the table for me based on the data in the Word doc. In other words, the macro would need to search the doc for the label in the Name column, then find the next instance of each of the % column labels and fill the rows accordingly. Hopefully this makes sense.