Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 10-21-2014, 01:53 PM
macropod's Avatar
macropod macropod is offline Auto repeat selected cells from tables into a summary Windows 7 64bit Auto repeat selected cells from tables into a summary Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Aside from what appears to be a desire to keep everything in tables, what you're describing could be handled quite easily via a Table of Contents (TOC) field. All you need do is use Heading Styles for the various recommendations (or use switches in the TOC field to employ your own set of Styles). Updating a TOC field to reflect changes to the document typically requires doing no more than a Print Preview or Ctrl-A, F9.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-21-2014, 01:59 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

Can you have more than 1 toc in a document? The report already has a main toc. The tables are used to maintain uniformity of report styles across the whole team so is a must have.
Reply With Quote
  #4  
Old 10-21-2014, 02:03 PM
macropod's Avatar
macropod macropod is offline Auto repeat selected cells from tables into a summary Windows 7 64bit Auto repeat selected cells from tables into a summary Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

You can have as many TOCs as you like. You can restrict their scope via bookmarks (to limit them to a particular range) and/or by the Styles they are specified to work with. Thus, if your document uses Heading Styles 1-3 for the main Table of Contents, you might use Heading Styles 8 & 9 for the Recommendations Table of Contents. Neither Table of Contents would then contain any content from the other.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-21-2014, 02:07 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

Brilliant! Thank you, if nothing else it's a starting point. Not been able to assign bookmarks as the table is dragged from the building blocks bit. Will let you know how this pans out. Thanks
Reply With Quote
  #6  
Old 10-21-2014, 05:24 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

Ok, this almost looks do-able as a toc. Is there any way of having 3 headings on 1 row like:

Heading 1 - Heading 2 - heading 3

Rather than

Heading 1
Heading 2
Heading 3

As this will read as:
Reference number - Affected Area - Corrective Action

Eg:

12/14 - Kitchen - Hole leading through external wall needs to be filled

The document is A4 landscape and this would prevent a lot of dead space.

Thanks in advance
Reply With Quote
  #7  
Old 10-21-2014, 06:58 PM
macropod's Avatar
macropod macropod is offline Auto repeat selected cells from tables into a summary Windows 7 64bit Auto repeat selected cells from tables into a summary Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

No, a TOC requires a separate paragraph break for each entry.

However, in the probably-unlikely scenario your Reference number, Affected Area & Corrective Action paragraphs all have consistent line counts (even if they're not all the same), you could simulate such a structure with a 3-column table, each holding a separate TOC for the corresponding Heading Styles.

The alternative, once a document has been finalised, is to convert the TOC to text (by selecting it and pressing Ctrl-Shift-F9), then replacing any unwanted paragraph breaks.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 10-22-2014, 07:59 AM
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

Thank you so much for your help on this... Learnt over the day to assign the different heading styles, assign ToC styles, get each ToC into a table column and wrote a macro to update all in one go (have to make it foolproof). It works like a treat, although to begin with it kept messing my main ToC at the start of the document (probably before I worked out what I was doing with styles). All good now, thank you again for your help.
Reply With Quote
Reply



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 05:37 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