I've designed a Job sheet for work where all the information of certain jobs
are saved. I need to be able to open the template and have the consecutive
number of the sheet change. i.e. If my first job sheet is labeled as Job #
929 the next time I open the template I need it to read # 930. I'm completely
confused.

This type of thing can be done- the problem is arranging it to work
only once. If you open the template and the job number advances by one
and then you save the template, if we're not careful the next time you
open the file it will advance by one again, and create a lot of
confusion. So in order to create a bulletproof solution, can you
please describe how you will be using these files? For instance: you
have a Job sheet master template; you'll open it, use it, apply job
information, save it under a different file name, refer to it
periodically, etc.

"Dave O" wrote:

This type of thing can be done- the problem is arranging it to work
only once. If you open the template and the job number advances by one
and then you save the template, if we're not careful the next time you
open the file it will advance by one again, and create a lot of
confusion. So in order to create a bulletproof solution, can you
please describe how you will be using these files? For instance: you
have a Job sheet master template; you'll open it, use it, apply job
information, save it under a different file name, refer to it
periodically, etc.

That's exactly right. I'll be saving it under the actual job number and email that sheet to specified depts where it will be opened and changes may be made and saved again. The next time I open the original template it will be for a different job. I hope this clarifies it a bit.

"Dave O" wrote:

This type of thing can be done- the problem is arranging it to work
only once. If you open the template and the job number advances by one
and then you save the template, if we're not careful the next time you
open the file it will advance by one again, and create a lot of
confusion. So in order to create a bulletproof solution, can you
please describe how you will be using these files? For instance: you
have a Job sheet master template; you'll open it, use it, apply job
information, save it under a different file name, refer to it
periodically, etc.

I've figured out some code to make this work- but I need to know: is
there a cell in your Job sheet that is *** ALWAYS *** blank in the
template and that is *** ALWAYS *** completed when you apply job data
to a job? The date? The client name? Anything like that will do.

Forgot to mention: I need the tab name and cell address, too.

"Dave O" wrote:

Forgot to mention: I need the tab name and cell address, too.

I don't know if this is what you're referring to but I-3 is where the Job number would be. Is that right?

"Dave O" wrote:

I've figured out some code to make this work- but I need to know: is
there a cell in your Job sheet that is *** ALWAYS *** blank in the
template and that is *** ALWAYS *** completed when you apply job data
to a job? The date? The client name? Anything like that will do.

Yes. The sheet just has basic headings ie Job #, Date, Show name etc. that are completed every time I fill it out.