callumwk laid this down on his screen :
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 its the next day but if its 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. Save as wont work for this.

I can't imagine why you'd need more than 1 log sheet for any given day,
and so why not have it display today's log if one already exists so it
only inserts a new sheet if one is needed?

Also, I'd use a workbook template with macros so that you can start a
new file for each year if desired.

Also, why use a new sheet for each day when you can use 1 per month and
show daily entries for that month. This will dramatically reduce the
size of the file AND keep the log entries organized by fiscal period.
For that matter, you could probably store a whole year's worth of
entries on a single sheet and use outlines to separate the months.
There's at least 65,536 rows on a single sheet in early versions of
Excel (over 1 million in later versions) so I can't imagine you needing
more than 1 sheet per year, 1 per month being surely enough!

Once you determine a more practical approach then the log sheet can be
used as a template for inserting new sheets as needed, OR if using 1
sheet per month OR one sheet per year you can insert all sheets and
just reuse the workbook continuously, archiving a copy for each fiscal
year if desired.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion