Automatic numbering

[bob]

How do you add automatic numbering sequence for a macro in
Office XP 2002 in Excel?

Thank you

 

[John McGimpsey]

your question is rather ambiguous. There are myriad ways to get
"automatic" numbers in a sequence. What are you trying to do? Are there
any constraints on the sequence? Will this sequence be per workbook, per
workstation, or per network?

 

[Bob]

-----Original Message-----
your question is rather ambiguous. There are myriad ways to get
"automatic" numbers in a sequence. What are you trying to do? Are there
any constraints on the sequence? Will this sequence be per workbook, per
workstation, or per network?



.
Sorry, there's 1 template for my invoices i'm using for

every invoice for that 1 workbook. I would like to have
each new invoice be the next number in sequence. I don't
know what the process is needed to get there and change
it, too see if any constraints are there. I'd appreciate
your help! Thank you.