Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-21-2014, 01:15 PM
AdieReeves AdieReeves is offline Auto repeat selected cells from tables into a summary Windows XP Auto repeat selected cells from tables into a summary Office 2007
Novice
Auto repeat selected cells from tables into a summary
 
Join Date: Oct 2014
Posts: 9
AdieReeves is on a distinguished road
Default Auto repeat selected cells from tables into a summary


I wonder if anyone could solve a problem for me. I have created a word template for the reports we write at work. It is set up as a series of tables (in word 2007) of which the basics are shown when the file is opened. As we inspect premises that could have 2,3,10 or 100 areas I have a macro that adds a new copy of the table from the building blocks within the template. At any given section of this we may run another macro that adds a RECOMMENDATIONS table again from building blocks. This contains space for an area, a reference number, narrative, photos blah blah blah. These recommendations tables can appear ANYWHERE or even NOWHERE in the document, there can be none, 1, 5, 100 etc etc. at the very end of the report I have a very simple table of 3 columns, reference, area and recommendation. This is a summary the client has to have on the sign off page. MY QUESTION (finally) is.... Is there any way that considering the almost random nature and how one document will never be the same as another that I can else either a macro or bookmarks system (bearing in mind the blank tables come from building blocks) to scan the document for the RECOMMENDATIONS tables and copy the 3 required element into the summary table at the end. And repeat for as many recommendations as are in the document. The recommendations table is built up of uneven cell sizes, some are merged to keep the aesthetics pretty any help appreciated. This would help as we currently have to keep scrolling up and down the document cutting and pasting... Quite often through 40-50 pages...

Last edited by AdieReeves; 10-21-2014 at 01:22 PM. Reason: Missed a bit out
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Rollup Summary Tasks to Project Summary Task shep555 Project 1 05-24-2014 12:28 PM
repeat selected table row as header eNGiNe Word 2 10-15-2013 11:16 PM
Repeat formula 5 times and repeat? Jenny345 Excel 4 06-14-2013 04:37 PM
Auto repeat selected cells from tables into a summary Macro to apply style to selected tables ubns Word 1 08-02-2012 04:09 AM
How to keep orientation when printing Selected Cells punkrae Excel 1 04-09-2012 05:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.


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