It probably would have been helpful to say what code isn't working for
you. Here's one method:

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

In article ,
Jdean wrote:

I need to Sequential number an excel 2000 template. Help Please. I have
tried a piece of VBA code I found, and it works fine while still a
worksheet, but gets macro errors when Saved as a Template w/tracking.
Thanks :) for any help in advance.