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.

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.

I am writing an excel worksheet for purchase order with auto-number,
vendor address look up, etc. and I will make it freeware ($5 donation
suggested). It is almost done. You could email me your template, and
I will customize it for you. Or just wait a week, and I will post
where to download with its own PO template.

- ken

(BrianB) wrote in message om...
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.