I hope someone can help me with the following problem.
I have a table that has a couple of subtotals. I have split the table and subtotals into different tables for each section and applied bookmarks to all sections. I have applied a bookmark called Table1 to the first table, Table2 etc. I have called the subtotal rows st1, st2 etc (I have not used these as yet in my calculation) – See attached document.
I have managed to get the formulas for each section to work but I cannot find any information on what to add in this formula if a section is deleted. Eg if the table inside the Table2 bookmark is deleted what would add to the formula so that the bookmark will be ignored and not return the error !Undefined bookmark, TABLE 2.
Inside the field I have the following:
{ =SUM(Table1 B:B)-SUM(Table2 B:B)-SUM(Table3 B:B)-SUM(Table4 B:B) # “$#,##0.00” }
I found a very good document on this site on Word Field Maths which helped me up to this point but countless searches on google does not bring any results for this type of query.
I have no knowledge of vba so I cannot use vba to fix this problem.
Any help would be greatly appreciated.
