auto insert invoice number that increases by one each time opened

[Michael HPSC]

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.

 

[Paul Sheppard]

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.

Hi Michael

Have a look at this thread

http://www.excelforum.com/showthread.php?t=483165&highlight=INVOICE

 

[Michael HPSC]

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]

Dear Paul,
The links and subsequent ideas and formulas that you put me onto are a
godsend. However I still have the issue of many users using this same
worksheet in a busy office, consequently the efficiency of producing a
consecutive number ever time the file is opened can create a problem from the
perspective that it does not matter what reason you open this file after its
creation it will always increase it number by one increment even if it is to
only view the file and edit figures or formats for whatever reason. The ideal
situation would be to set up a template that increments by one upon opening
but if 'safe as' if activated the incrementing factor becomes static.
Any ideas or amendimentsif to how I can handile this. Any advice would be
helpful and cheerfully welcomed.
KIndest regards
Michael the intermediate