|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy range of cells from excel to either bookmarks or to insert in table in word
Hello
Before i start. i have posted this question on Excel Forum and MrExcel and i have yet to have a reply. I seem to be struggling to do the following: Copy multiple cells from Excel to an 8 column table in Word. The row length needs to be dynamic as this depends on the number of selections the user makes from the drop down list in Excel. I cannot seem to find anything that allows me using VBA to select the options that the user has chosen and paste to a table(already exists in Word) which retains the table formatting. The table is in landscape view if that makes a difference. I apologise for cross posting but struggling to find an answer is an understatement. I do have some knowledge of Access VBA so the coding side is not to problematic but i understand that there are some differences in VBA with Excel. i have attached the Excel document i am using, although incomplete as i just wanted to understand the programming side before i entered more data to the drop down lists. Thanks in advance. |
#2
|
||||
|
||||
Quote:
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters See also: Excel Forum's Cross-Posting policy in rule 8: Forum Rules Mr Excel's policy on Cross-Posting in rule 13: Message Board Rules | MrExcel Message Board
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
cross posts
|
#4
|
||||
|
||||
Mr Excel: Export data from excel to word table | MrExcel Message Board
As indicated in my previous reply, both cross-post links are required and you must supply cross-post links at both the other forums as well - for between each other and for here.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
I still see no evidence you've complied with the cross-posting rules at either Excel Forum or Mr Excel. Until you do, don't expect any help here.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
to be honest I don't know what more info you want.
|
#7
|
||||
|
||||
Read Post #2. Compliance is required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert Excel cells Word Table BUT Fit? | markg2 | Word Tables | 9 | 02-09-2020 02:25 PM |
Insert Range from Excel File into Word | ChelseaCat | Word | 2 | 07-15-2019 10:47 AM |
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
How to insert a table using bookmarks in a document | Catty | Word VBA | 3 | 05-04-2015 03:05 AM |
Set range for merged Word table cells? | tinfanide | Word VBA | 1 | 02-06-2012 05:57 AM |