Hi - I am posting for first time and have very limited VBA knowledge. My aim is to automate the following task:

I am currently manually copying data from several intranet pages into tables on several separate Word docs. It is not a huge amount of data, only one table of 6 col x 2 rows in each Word doc, and is done monthly.

I have set up automated Excel reports (separate for each Word doc) from the intranet application and now need to get the data into the relevant Word table, correctly formatted.

The added problems are that
1) the macro needs to check the Excel data for blank cells and if it detects one, write "N/A" in the corresponding place in the Word table plus the one below in the Word table (even though this one will have data in the Excel file)
2) for some of the Word tables, the macro will need to re-order one column of Excel data, moving it from the middle in Excel to the last column of the Word table
3) the file names of the automated Excel reports are generated automatically and are not predictable

Attached are examples.

sample excel.xlsx
sample word.doc

Thanks in advance