I'd suggest using Word to run a mailmerge for this. No macros required and, once its set up correctly, you can produce further invoices anytime the data are updated. Do note, though, that a mailmerge will work with only one worksheet as the data source, so you'd need to have a worksheet that pulls together all the data needed for the invoices, with one record per row.

Without seeing your workbook, it would be difficult for any specific advice to be given, especially where macros are concerned.

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