View Single Post
 
Old 05-22-2014, 06:20 AM
Mel_Herndon Mel_Herndon is offline Windows 7 64bit Office 2010 64bit
Novice
 
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