Master Workbook used as my template?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook master I use as my master template for my jobs.

I am wondering if it is possible to have them have a number sequence to
follow and automatically number as the next job when saved as.

For eg: I open my master and save it as ...., then I have to go into the
worksheet in the work book and re number it as well.
Say I save it as Job # 1000, then I have to enter it in a few worksheets in
the workbook. But when I save the next one Job # 1001, is it possible to have
that number automatically change for me inside the worksheets?

I am new to excel and love the program and I am amazed the stuff you can do
in it, so I am trying for the stars!!!

Thanks tb
 
Paul, Thanks for your info, I looked at it, these are macros correct? I am
quite new to excel and we have not yet started using any macros at my place
of work. So I am not formiliar with or would not know where to start with
macros.

Would this be my easier way to do what I am trying to do?
Thanks
tb
 
Back
Top