View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ann~ Ann~ is offline
external usenet poster
 
Posts: 1
Default Create, name, open, and enter data in new sheet - from template

I keep track of monthly finances with a simple spreadsheet. I keep one sheet
unedited to copy/paste each month into a new sheet (current month-year), then
fill in all the relevant data (dollar amounts/rates/misc fees/etc).

What I would like to have is a button or something that will create a copy
of this original/template, name it (with the current month-year), open it so
it's the currently viewed screen, and have the name of the sheet (current
month-year) in cell A1.

I haven't a clue where to start so any help will be greatly appreciated.

Many thanks,
Ann~