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

[hinchi1]

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.