Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPY WORD DATA TO EXCEL | Excel Discussion (Misc queries) | |||
Copy data into/from textbox | Excel Worksheet Functions | |||
Copy a word doc to excel and hyperlink data between the 2. | Charts and Charting in Excel | |||
how do i draw a textbox on chart and copy onto word? | Charts and Charting in Excel | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |