So I'm going to be building up a suite of documents (potentially word/powerpoint/publisher variations) all of which will contain some of the same words/numbers which will change during the drafting period and potentially for updates in the future.
I'm thinking along the lines of having a master excel file where each row or column is one of the changeable elements, as it's found in all the docs. Then changing this one master lookup data point changes all of the documents hanging off it.
Can this be done in an efficient way? It's not mail merge so I'm struggling to know what to google for....
Ta!
You can paste from Excel into Word as linked object, so it updates when Excel is updated.
Or you could put your original data in Access and insert a sql query to get the latest value.
Not sure if either of those are what you want to do, but something to Google for.
So you're talking about a sort of master document index?
Controlling rivisions and suitability etc?
Or you could put your original data in Access
What's the OP done to upset you? 🙂
.
