I need to have a record number change for every record
 

Hello I am new to excel and I am trying to make a form for my business but I
need the record number to change every time I add a new record like 100, then
101 and 103 so on can someone please help me
Thanks so much
Frank

I need to have a record number change for every record
 

See John McGimpsey's site for methods of sequential numbering.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben MS Excel MVP

On Sat, 11 Jul 2009 20:58:01 -0700, Puget Sound Courier Service <Puget Sound
Courier wrote:

Hello I am new to excel and I am trying to make a form for my business but I
need the record number to change every time I add a new record like 100, then
101 and 103 so on can someone please help me
Thanks so much
Frank