Is it possible to create a Word document using Excel VBA and data contained in the Excel worksheet?

Answer 1

You can link a worksheet (or a chart that's part of it) to a Word document that automatically updates when the sheet does. Look here for an example: https://www.officetooltips.com/word_2016/tips/creating__updating__locking_and_unlocking_links.html