Hi GoEnviro,

This kind of thing is best done in Excel (probably with the use of a lookup table), from where you could copy & paste the output table into Word, either as an embedded object or as a linked object. With the latter, any changes to the Excel data will update the Word document. Alternatively, you may be able to do the whole job in Excel, without involving Word at all.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]