Auto-populate qualitative data into excel

[workingwithdata]

I have a number of Word docs that are filled out by faculty on their research activities. I'd like to take the information from those Word docs and import them into an Excel spreadsheet.

I have attached two sample files : 1. Sample CV, and 2. the sample excel that I am populating.

Those highlighted in yellow are what need to be populated. As most of the data are qualitative and are not in tables, I am wondering if there is any VBA code that can auto-populate them into my excel sheet (refer to first two tabs for example).

Appreciate advice, please.

[macropod]

What you're after would not be possible unless all the files have the same format (e.g. the table data are always in the 4th table in the document [or at least a table preceded by the 'Citation Summary' heading], every document has portions titled preceding what you've highlighted in yellow with the exact text you've used, etc.). You would also have to account for the likely different number of entries under each of those headings for output to the different worksheets. This is all rather more complex than it would be reasonable to expect someone to code for free. That said, see: https://www.excelforum.com/excel-pro...from-word.html