I would like to copy an excel range "Sheet1. range A1:F35" to a Word document with the following path:
The macro should run using Sheet1 as the Active Sheet.
Everytime the macro is run, it should add a new page to the word document
I have included an example of the spreadsheet.