What I need is probably really simple but I can’t figure it out.
I have a bunch of tables in excel that I want to copy into word; with the appearance matching how it would look if I did the copy and paste manually.
Each table is on its own worksheet and is a named range (local name... name is same on each sheet), each sheet also contains a named cell (again... local name... same on each sheet) with the title of the table.
I want the macro to paste the tables into word with the table title separating them, captioned as a table in word.
Ie the macro would do the same as if I:
1) insert a caption with the ‘table’ label
2) the append with the title copied from the value of the title cell
3) copy and paste the named range from the worksheet
4) change the table property to be centrally aligned on the page
Rinse and repeat with the data from the next worksheet.