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

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

Guest

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 :)
 
i forgot to mention i would like all this to happen by clicking a button on
the sheet
thanx :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help please..... can this be done 4
More efficient macro help 4
Faxing to a number which is a cell value 1
Save with ref. to cell A1 2
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
Saving an Excel Wookbook to a Variable? 1
How to use templates with macros 1
Stopping a macro to edit the template then re-saving the macro for use 4

Back
Top