I can't begine to tell you how grateful I am at the effort put in by all the
people concerned with dealing with tricky issues being explored by
intermediated users like myself. I now realise how little I know when it
comes formulas and how they best to utilise them. I have not actually put
this to the test yet but by all accounts it is what I'm looking for. I
suppose the only question left is how do you manage to go back and review an
invoice with this macro installed without increasing the numeral value of the
invoice number. I still have a play and see what I can set up.
But once again thank you.

"Michael HPSC" wrote:

I would like to set up an invoice that increases the invoice number by one
every time it's opened. The reason is that this invoice will be used by a
number of people in the same office.