Quinn,

I am fairly sure that it can be done.

Play with the macro recorder to to get basic code for all the steps needed.
(use a copy of your template)

You can create a file name from the cells and save with that name:

Dim fname as string
fname = Range("H13") & " " & Range("E12")

' remove & " " if you don't want a space.

than add 1 to Range("E12"), clear all the data and resave
as the original file name.
Range("E12") = Range("E12") + 1

Range("......").Clearcontents

Hope this gets you started.

Post back and let us know how it works.
Also let us know if you need more specific code.

--
steveB

Remove "AYN" from email to respond
"QuinnDexter" wrote in message
...
Hi thanks for taking the time to read this even if it cant be done ...
i have a template that opens up after incerting relavent info i need a
macro
that can save the work book taking the file name from 2 cells (H13-E12)
and
also be un editable then add 1 to the number in cell E12 on the origanal
template clear all data just entered and save as a new template over
writing
the old one, the aim is to create a new and unchangeable number in cell
E12
each time the the workbook is saved. and need this to work from a button
in
the work sheet ....first off is this possible if so can
anyone help

thanx :)