Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create an autonumber similar to Access in Excel?
I need to be able to create an autonumber on an invoice in a Spreadsheet
using MS Excel 2003. -- Netty |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create an autonumber similar to Access in Excel?
You need to store the "next available number" at a secure place in your .xls
(say another sheet with all your parameters). Every time you generate an invoice you need to assign the next available number to the new invoice; and then increment your counter by 1 and save the new "next available number" so that you have it when you create a new invoice. Hope this helps. "awebb" wrote: I need to be able to create an autonumber on an invoice in a Spreadsheet using MS Excel 2003. -- Netty |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create an autonumber similar to Access in Excel?
See http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "DKS" wrote in message ... You need to store the "next available number" at a secure place in your ..xls (say another sheet with all your parameters). Every time you generate an invoice you need to assign the next available number to the new invoice; and then increment your counter by 1 and save the new "next available number" so that you have it when you create a new invoice. Hope this helps. "awebb" wrote: I need to be able to create an autonumber on an invoice in a Spreadsheet using MS Excel 2003. -- Netty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access autonumber field changes to date format when Excel imports | Excel Discussion (Misc queries) | |||
Adding rows in Excel Similar to Access | Excel Discussion (Misc queries) | |||
Access form in Excel Autonumber | Excel Discussion (Misc queries) | |||
Is there a similar users group for Access? | Excel Discussion (Misc queries) | |||
Deploy Excel similar to Access Runtime | Excel Programming |