macro to save wookbook add 1 to to a ref No. clear cells
 

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. first off is this possible if so can
anyone help

thanx :)

macro to save wookbook add 1 to to a ref No. clear cells
 

i forgot to mention i would like all this to happen by clicking a button on
the sheet
thanx :)

"QuinnDexter" wrote:

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. first off is this possible if so can
anyone help

thanx :)