sequential numbering

[Connie]

I have created a template to print information on tags, we may print ten tags
with the same information, but each tag needs a new number. How do I make it
so the cell where the tag number is stored increases by 1.

 

[Sreeni72]

try ..

file -> edit -> Fill -> series

 

[Gord Dibben]

See John McGimpsey's site for methods.

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


Gord Dibben MS Excel MVP