Auto number / macro creation

  • Thread starter Thread starter Fiona
  • Start date Start date
F

Fiona

How can Excel number all cells in A1 to automatically
include a sequencial numbering system as soon as an entry
in the adjacent cell is updated?

Eg, Cells 10-100 are blank. When a user enters data into
B10, B11 - B100 etc. I want Excel to automatically enter
in Column A a sequential number used as an identifier.

Thanks.
F
 
Hi!

You can do this with formulas depending on what type of
numbering system you want to use. Something like this
maybe:

In cells A10:An:

=IF(B10="","",ROW()-9)

This will start with a number sequence of 1.

Biff
 
I use the following formula, which works very well
=IF(AND(A1="",C1=""),"",IF(B2="","",A1+1))
 

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

Multiple Task needed in Excel 2
Macro Relative Cells 3
Real-time sorting 11
Adding only NONBLANK cells 2
auto fill cells with "formulas" from within the same worksheet 2
Excel number format 3
Calculate (Auto Fill) cells with numbers and text. 3
Macro to save information into a table 1

Back
Top