Quote:
Originally Posted by gmayor
See the attached which should do what you require, however using a repeating section content control to duplicate the table doesn't appear to produce the desired results, so I would suggest using a button either on the document (as in the attached) or on the ribbon to add tables as required.
The process recalculates the totals after each change so the totals should remain valid if the user changes a control.
|
awesome! the table update works well in your example,
only issue is 'critical' doesnt show in the chart for some reason not sure why
other times
if i copy/paste all of this into another doc and press the "add a Table" button, it pastes all the way at the end of document, is there any way to send it to a certain spot in the document? I have a tables of contents reference called 'Vulnerability Details' that the button should add under
also trying to figure out how to copy the button from your test doc properly, sometimes when i copy/paste it i get a reference errors
"the requested member of the collection does not exist" for : Set oCell = oTable.Cell(5, 2)
i need to move the chart and table to a different part of the doc than the table created
if i were to put the button in a ribbon how would i go about doing that? otherwise the button prints out on the page, or is there a way to prevent the button from printing
Quote:
Originally Posted by macropod
Instead of directing users to files hosted elsewhere, please attach them to the actual post. You do so via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen. In this case, I've done that for you.
|
thanks! sorry i missed that button