Autonumber

N

NG_Leeds

Sorry my fault I probably didn't explain it correctly, I do not wish t
count total, just have a number reference which is allocated to eah
item at a specific point eg.a1=1, b1=2, c1=3, but if a row was eneter
before B1 it would adjust so that a1=1, b1=2,c1=3,d1=
 
J

JulieD

Hi

if you mean columns (A1, B1, C1)
then in A1 type
=COLUMN()
and fill across .. when you insert a new column the others will renumber and
you'll just have to copy the formula from the adjacent column into the new
one.

If you mean rows (A1, A2, A3) then in A1 type
=ROW()
and fill down ... when you insert a new row, the others will renumber and
you'll just have to copy the formula again.

Cheers
JulieD
 
Top