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.

Attached Files

RA Selector Macro1.xlsm (38.6 KB, 10 views)

Kindly provide cross-post links here and at both Excel Forum and Mr Excel.
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]

Excel Forum: Copy range of cells from excel to either bookmarks or to insert in table in word

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]

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]

to be honest I don't know what more info you want.

Read Post #2. Compliance is required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]