Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2014, 06:20 AM
Mel_Herndon Mel_Herndon is offline Copy content control entries to next table next page Windows 7 64bit Copy content control entries to next table next page Office 2010 64bit
Novice
Copy content control entries to next table next page
 
Join Date: May 2014
Location: Cypress, TX
Posts: 2
Mel_Herndon is on a distinguished road
Question Copy content control entries to next table next page

I hope this can be done fairly easy. We have documentation clerks that enter information on multiple word documents (I'm combining all pages into one document). Some of this information is repetitive so I have used content controls. I have a table created with static text in cells. Examples are Date, Report Number, Technician, OA Number, Witness, etc. These cells will be identical on each page of the document. What I would like to learn how to do is use VBA to look at the cells, take the information that has been entered into the content control (date, rtf) and have it look to the other pages in the document and place what was entered on the first page in the first table. The idea is that only one table gets populated with the needed information and then it is copied and pasted to the other tables in the subsequent pages. I have put up a screen shot of the basic form layout with the controls in place. The last piece of the puzzle is the code to copy and paste the information to all the other tables. I've attached a screenshot of the form layout:



form.jpg
Reply With Quote
  #2  
Old 05-22-2014, 04:14 PM
macropod's Avatar
macropod macropod is offline Copy content control entries to next table next page Windows 7 32bit Copy content control entries to next table next page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

See: http://gregmaxey.com/word_tip_pages/repeating_data.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-22-2014, 05:07 PM
Mel_Herndon Mel_Herndon is offline Copy content control entries to next table next page Windows 7 64bit Copy content control entries to next table next page Office 2010 64bit
Novice
Copy content control entries to next table next page
 
Join Date: May 2014
Location: Cypress, TX
Posts: 2
Mel_Herndon is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Thank you so much!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy content control entries to next table next page Allow Multiple Content Control same cell of form table DeborahBartlett Word 1 01-04-2014 11:06 AM
Copy content control entries to next table next page Deleting a table from a content control -- preserving the content control BrainSlugs83 Word Tables 8 11-14-2013 03:06 AM
Copy content control entries to next table next page Clearing content control tick box within table jillapass Word VBA 1 08-08-2012 04:58 PM
Word2010 check boxes and plain text content control boxes in same table fcsungard Word 5 06-01-2012 01:16 AM
Copy content control entries to next table next page Page number in table of Content Ritu Office 1 09-19-2011 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:15 PM.


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