|I am trying to automate our version control process so we don't get smacked by ISO auditors and I'm having some difficulty.|
Currently, we have all ISO documents on one network share with each section being its own word document. Within each document is contained a Revision letter (A, B, C, D, etc). Then, we have a master revision level tracking document (currently word but this could be changed to excel if necessary) that contains a list of all ISO documents and their current revision (A, B, C, D, etc.).
The goal is to just be able to update the Revision letter in each document, and then have the master revision level tracking document (either by links or whatever will work!) update itself with the individual documents' revision letters.
I've tried doing this with Bookmarks and links in word--and it works...until you change a document's revision letter. Because the bookmark lets you select and mark highlighted text (e.g "E"), when the "E" is changed to "F", the bookmark disappears as soon as the "E" disappears, rendering the link useless.
Next I tried embedding an excel sheet (for a single cell in which to place the revision letter) in the section documents so that I could instead reference the cell (which would allow data to be changed and referenced without the use of bookmarks), but I cannot seem to successfully link it, and my guess is because it's embedded.
Anyone have any ideas?
Thanks, all, in advance!