I don't really follow your latest suggestion. Is this to read data from another file which, in my case, would hold the last used number?

I got around my issue using your first method and adapting it. The template now does not hold a job number, I keep that in a separate sheet. When the user uses the template to set up a new sheet he/she then clicks on a "Job No." button which triggers a macro to read the Job no., add one to it and write it back. The new job no. is then used in the new worksheet.

Thanks for your help. You pointed me in the right direction.

Regards,
RaceyBee