View Single Post
  #1   Report Post  
Fiona
 
Posts: n/a
Default Auto number / macro creation

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