Is there 'autonumber' in excel?

  • Thread starter Thread starter Souljah
  • Start date Start date
S

Souljah

Can anyone help me?
I just want something along the lines of what is available in Access
to enter a new number everytime a new entry is made..... I want to hav
an autonumber for orders. Sorry its such a noob question
 
Hi
there is no build-in feature like autonumber in access. Some
workarounds
If you want your number in column A enter the following in A1:
=IF(B1<>"",ROW(),"")
this will create a number (the row number) if you enter something in
column B. Note: This number is not attached to your data. that is if
you delete a row, the numbers will change. same is true for sorting.

Another way could be to use the worksheet_change event. Test for column
B and if an entry is made, put a number in column A

HTH
Frank
 
Do all orders have to have a unique ID? Surely the order ID only has
to be unique to each customer? Is there a natural key you could use
e.g. a composite key based on the the customer ID column plus the
date/time of the order?

Autonumber isn't a great feature of MS Access so there's no point
trying to re-creating it in Excel.
 
Back
Top