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.

try ..

file - edit - Fill - series

"Connie" wrote:

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.

See John McGimpsey's site for methods.

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


Gord Dibben MS Excel MVP

On Fri, 20 Jun 2008 10:15:03 -0700, Connie
wrote:

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.