I'm using Word 2003 to generate large, complex quotations for consultancy
projects. Projects are split into stages, and each stage consists of a number
of days at up to 3 different fee rates. So, the quotes are a combination of
text and calculations.
I have embedded an Excel table for each stage of the quote, which calculates
the stage costs (e.g. so many days at one rate plus so many days at another
etc and then a total cost for the stage). But I then have to manually add the
stage totals to get an overall cost for the project.
Is there any way to link the embedded objects within Word, so that the
individual stage costs are added together to generate a total project cost?
Many thanks for your attention.