Hi there


I need help with a vba code to copy from a table in word to Excel. However the table has some merged columns, line and paragraph breaks. I would like the user 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 other issue is that the word table columns 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.

Also, there is usually multiple tables in the word document.

Word table example:

Word table.jpg

Excel table is always in format

Excel table.jpg

Thanks
Ola