I trying to automate a process of creating a monthly report - I have an Excel workbook where I update the tables and a few charts are generated from the data, which then I have to transfer to a Word document. The tables and the charts always go to the same places in the Word file, charts are always the same size and the tables are different each month. What I do now is manually delete the old tables/charts from the Word document, then copy the new tables/charts from Excel one by one and paste them into their places in the Word document where I do some formatting so they fit the page.
It is the same process every time and I am trying to figure out a way to do this automatically to save some time. Something like recording a macro that takes stuff from Excel and pastes it into a pre-defined space in Word while deleting the old data and doing some formatting.
Any ideas about how this could be done?