View Full Version : VBA to copy specific columns from word table to Excel

07-19-2019, 01:08 AM
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:


Excel table is always in format
Is this something that can be done via VBA and if any ideas on how to get started.