Export data from excel to word table

[hinchi1]

I have a basic drop down list in Excel(attached), which is incomplete. is there a way to select multiple options from the list and paste into cells below the list? i then want to copy and paste these cells in to a table that is already created in word and maintain the Word formatting. i am familiar with VBA using Access so i understand how to get/ create objects, but the process to copy excel data to either to a table or bookmark in word escapes me. I could create the table in excel but again how do i force formatting when pasted in to the word document. The page layout in word is landscape with a table of 8 columns. the number of rows will be dynamic depending on the selection from the drop down list in excel.

 

[Fluff]

Hi & welcome to MrExcel.
Unfortunately this has been reported as cross posted Copy range of cells from excel to either bookmarks or to insert in table in word
and Copy range of cells from excel to either bookmarks or to insert in table in word

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.