How Generate a Fresh Copies Of an Excel Document?

General discussion on MS Excel and its spreadsheets.

How Generate a Fresh Copies Of an Excel Document?

Postby Elwood M. Walker » Tue May 06, 2014 4:49 am

Ok this is what I need to do with a workbook

The workbook is a log book for a flying club.
I need to be able to generate a new copy for almost every day, probably by using a button on 'yesterdays' one.

It needs to be date stamped so it will be called something like Log_23_03_12 then when you add new sheet it will be stamped Log_24_03_12 if it’s the next day but if it’s the same day it should be something like Log(2) _23_03_12.
Then each year you would start a new spreadsheet and archive the old one.


I think if I keep the first worksheet as a template so call it Log_Master. And never fill it in so when you make new sheet it is empty not full with last entries. Use this as the copy sheet. I need to work out how to copy all the sheet into a new sheet that is added after the last.

Good luck!!!!!!!

Thanks everyone in advance!
Also, I don't know much about coding, so help me a bit

Callum.W.K.
P.s.I don't think save as wont work for this.
Elwood M. Walker
 
Posts: 33
Joined: Mon Mar 24, 2014 6:09 am

Re: How Generate a Fresh Copies Of an Excel Document?

Postby LiverPAN » Mon May 12, 2014 5:35 am

Hi,

Perhaps you should consider using a worksheet template. See: http://www.ehow.com/how_13117_create...-template.html
LiverPAN
 
Posts: 24
Joined: Tue Mar 25, 2014 6:30 am

Re: How Generate a Fresh Copies Of an Excel Document?

Postby UniSET » Mon May 12, 2014 5:41 am

To generate a fresh copies of an excel document read the articel "How to Create a Spreadsheet Template in Excel" by using this links http://www.ehow.com/how_13117_create...-template.html
Thanks,
UniSET
 
Posts: 22
Joined: Tue Mar 25, 2014 6:33 am


Return to MS Excel- Help Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron