I suggest that you use the following process :-

1. open template (which opens as a normal .xls)
2. update number (Range("I2").Value=Range("I2").Value+1)
3. SaveAs template (containing the new number for next time)
4. SaveAs normal .xls .... and continue.

Regards
BrianB
===========================================

"ray denneny" wrote in message ...
Hello and Thank You in advance.

I have a purchase order template that works well. What I
am hoping to do is get a new (and next in a series) number
to come up in cell I2 for each new sheet opened.

All help and ideas would be very much appreciated.