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.
Bookmarks