Hi,



At work we create reports with many sections. At the end of each section we assign a category A,B,C,D.

For clarity at the start of the report we put a cross reference matrix, with the heading (either level 1, 2 or 3) in one column, then 4 more columns called A, B, C, and D. There is then a black dot (or any mark) in the column linking to the sections category.

I was wondring if via VBA or another method it is possible that word automatically updates the position of the mark when the category is changed. It would be great if the whole table is made automatically, but this is not completely necesarry, the main aim is for the mark associated with the category to be automatically updated.

I can if it helps attach an example document with the cross reference matrix.

Cheers

Hi Luke
Can you post a sample so we can see exactly what is needed.
Thanks
Tony

Hi Tony

I have attached a document, its a brief example of the report, ive just removed the text. Its also smaller, only about 5 headings where as a normal report will have around 100-200. So manually changing the risk matrix is tedious and can cause errors, hence this post.

Thanks

Attached Files

Example.docx (126.4 KB, 12 views)

We also use within the report the boxes as attached to this post instead of where it sais "This is Category B Risk" in the first example. To be honest it would be better to work it with this type of box instead.

Thanks

Attached Files

Example 2.docx (13.6 KB, 10 views)

Hi Luke
I have had a look at your issue and unfortuntaley there is no way to do this in Word that I know of. There is a way of embedding Excel spreadsheets into a Word document to achieve this functionality but it may be a bit messy.
Tony

Hi Luke
I will take another look at this sometime tomorrow. There may be a way to do it in Word after all.
Tony