Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto insert invoice number that increases by one each time opened
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. |
#2
|
|||
|
|||
auto insert invoice number that increases by one each time opened
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. Hi Michael Have a look at this thread http://www.excelforum.com/showthread...hlight=INVOICE -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=484628 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto insert invoice number that increases by one each time opened
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto insert invoice number that increases by one each time opened
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 "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto number invoices in Excel | Excel Worksheet Functions | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
How do I add an auto number to a worksheet | Excel Discussion (Misc queries) | |||
How do I automatically pull a new invoice number into an excel te. | Excel Discussion (Misc queries) | |||
how do I get an invoice to automatically insert the next invoice . | New Users to Excel |