![]() |
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