Dropdown list dependency and autofill

[LustNik]

For some reason this solution removes the dropdown options in the "risiko" cells upon closing and then opening the document. It seems to only be the case if nothing has been filled into the cell before exiting.

Preferably I would like to be able to take a copy of the document before filling anything into the table, so I can make multiple copies of that same doc.

Originally Posted by macropod

Create one each of your Relevans & Risiko content controls, both with their relevant drop-down entries, then copy them to each of the other cells. Having done that, run the following macro:
...
From then on, the only macro you need in the document is: