Dear Team

I have an Excel spreadsheet that is a tabulated list of activities with their associated % complete details. I need to create a "Word" document from this spreadsheet and populate within specific word table cells information created from the Excel spreadsheet. I can open/close the work document with basic VBA however, I am a little lost with the copying of the specific Excel cell data to word cell data!! To add to my difficulty the initial run of Excel to word doc creation will follow by daily updates of these created reports so I am unsure how I can maintain links from Excel cells to word cells (and make it easy for ALL to use) when the document titles will be changed e.g. initial run will be from "Master" Excel spreadsheet and Word template, subsequent updates will be Site XXXXX Excel spreadsheet to Site XXXXXX Word report? My VBA is basic so any help / guidance would be greatly appreciated. for additonal info, my original report was 100% Excel and simple used two separate tabs, 1 for calculations and 1 for the report however, the area for daily activities (group of merged cells) were limiting the amount of text to be entered on a fixed two page report format so I chose to use Word (as most people are familiar with this application) for the report template.