Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-17-2020, 01:23 AM
hinchi1 hinchi1 is offline Copy range of cells from excel to either bookmarks or to insert in table in word Windows 10 Copy range of cells from excel to either bookmarks or to insert in table in word Office 2016
Novice
Copy range of cells from excel to either bookmarks or to insert in table in word
 
Join Date: Apr 2020
Posts: 3
hinchi1 is on a distinguished road
Default 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.
Attached Files
File Type: xlsm RA Selector Macro1.xlsm (38.6 KB, 8 views)
Reply With Quote
  #2  
Old 04-17-2020, 02:27 AM
macropod's Avatar
macropod macropod is offline Copy range of cells from excel to either bookmarks or to insert in table in word Windows 7 64bit Copy range of cells from excel to either bookmarks or to insert in table in word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by hinchi1 View Post
i have posted this question on Excel Forum and MrExcel and i have yet to have a reply.
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]
Reply With Quote
  #3  
Old 04-17-2020, 02:48 AM
hinchi1 hinchi1 is offline Copy range of cells from excel to either bookmarks or to insert in table in word Windows 10 Copy range of cells from excel to either bookmarks or to insert in table in word Office 2016
Novice
Copy range of cells from excel to either bookmarks or to insert in table in word
 
Join Date: Apr 2020
Posts: 3
hinchi1 is on a distinguished road
Default cross posts

Excel Forum: Copy range of cells from excel to either bookmarks or to insert in table in word
Reply With Quote
  #4  
Old 04-17-2020, 03:04 AM
macropod's Avatar
macropod macropod is offline Copy range of cells from excel to either bookmarks or to insert in table in word Windows 7 64bit Copy range of cells from excel to either bookmarks or to insert in table in word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 04-17-2020, 04:15 PM
macropod's Avatar
macropod macropod is offline Copy range of cells from excel to either bookmarks or to insert in table in word Windows 7 64bit Copy range of cells from excel to either bookmarks or to insert in table in word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #6  
Old 04-27-2020, 09:00 AM
hinchi1 hinchi1 is offline Copy range of cells from excel to either bookmarks or to insert in table in word Windows 10 Copy range of cells from excel to either bookmarks or to insert in table in word Office 2016
Novice
Copy range of cells from excel to either bookmarks or to insert in table in word
 
Join Date: Apr 2020
Posts: 3
hinchi1 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
to be honest I don't know what more info you want.
Reply With Quote
  #7  
Old 04-27-2020, 01:55 PM
macropod's Avatar
macropod macropod is offline Copy range of cells from excel to either bookmarks or to insert in table in word Windows 7 64bit Copy range of cells from excel to either bookmarks or to insert in table in word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Read Post #2. Compliance is required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy range of cells from excel to either bookmarks or to insert in table in word 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
Copy range of cells from excel to either bookmarks or to insert in table in word Set range for merged Word table cells? tinfanide Word VBA 1 02-06-2012 05:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft