Nick,
That much I worked out<vbg>.
Sorry, I wasn't to clear. The issue revolves around how the invoice is
created, when to increment etc. Do you want to start from a template invoice
(this is tricky, as there is nowhere to store the number each time), or take
the last invoice and create anew from there, or have a invoice control
workbook that creates a new invoice, or something else? Do you want to
increment every time you save, on some other event, when you press a button
etc.
Before you can design a solution, you need to have worked out how the
business model operates, and design the solution around that.
Not trying to be awkward, just want to get there as quickly as possible.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)