Hi all

Please I need help to write a code to copy specific columns from a table in word to Excel. However the table has some merged columns, line breaks and paragraph breaks.

Ideally the user should to be able to click a button in Excel, select the word document and then copy and paste the data into the Excel template.


The main issue is that the columns in the table in Word could be in any order (with some columns missing or extra added) but the Excel template has a specific column locations and will only have 5 columns to be extracted but the title of the columns to extracted is always the same in both application. I don't know if it is possible to match the column titles in word to the Excel


Word table example:

word table.jpg



Excel table is always in format
excel table.jpg

Is this something that can be done via VBA and if any ideas on how to get started.

Thanks