ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy excel data (inc. textbox data) into Word (https://www.excelbanter.com/excel-discussion-misc-queries/154124-copy-excel-data-inc-textbox-data-into-word.html)

Sarah (OGI)

Copy excel data (inc. textbox data) into Word
 
I have a workbook with 13 worksheets. The first worksheet is where the user
enters all relevant details. These details are then pulled through into the
relevant worksheet, whether relating to Visit 1, Visit 2, etc.
Each of the Visit worksheets contain text in cells B7:D26 and a textbox
(from the control toolbox toolbar) from B28:D45.
I need to be able to create a macro which (through the use of a command
button on each visit sheet) will copy the details into a word document.
Firstly, how can I do this?
Secondly, I had considered using a word document with links from the excel
worksheet, but I think doing that would mean that I would need to create 12
separate Word files, one for each Visit worksheet, because the links are
defined?
Any ideas?


All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com