How do I create an autonumber similar to Access in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to create an autonumber on an invoice in a Spreadsheet
using MS Excel 2003.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an AutoNumber ID as a primary key 2
Excel Autonumber? 6
autonumbering invoices 3
How do i create an autonumber in excel 1
Is it possible to set up an AutoNumber in Excel? 1
Importing data from excel spreadsheet 1
New Spreadsheet Created Based on Value Column "O" (alpha) 5
Can I format cell to autonumber everytime I enter spreadsheet? 1

Back
Top