New Date-New Sheet

  • Thread starter Thread starter netsurfer802
  • Start date Start date
N

netsurfer802

I'm trying to make a template file for Excel that will automatically
see what the date was in the sheet just prior to inserting a new sheet
from a template; and, having the date be the next date.

Is there a formula or macro for this? (Example there are three sheets
by default in a workbook. In sheet 3, cell A, 1 it says 4/27/04. I
want to be able to insert the fourth sheet--from a template file--and
automatically have the new sheet display 4/28/04 in cell A, 1 of the
fourth sheet.) What formula or macro should be used for A, 1 of the
template file?

Thanks very much for any input.

--S--
 
I'm trying to make a template file for Excel that will automatically
see what the date was in the sheet just prior to inserting a new sheet
from a template; and, having the date be the next date.

Is there a formula or macro for this? (Example there are three sheets
by default in a workbook. In sheet 3, cell A, 1 it says 4/27/04. I
want to be able to insert the fourth sheet--from a template file--and
automatically have the new sheet display 4/28/04 in cell A, 1 of the
fourth sheet.) What formula or macro should be used for A, 1 of the
template file?

Thanks very much for any input.

--S--
Click to expand...
I'm adding more to this because I want to clarify more about what it
is
I'm looking for. Basically all the templates out there for Excel are
calendar templates which show only the month at the top for the entire
sheet.
I'm trying to make it say I have 1 sheet for 1 date, then the next
sheet for the next day...(like a simple day planner but with the full
date at the top).

Example:

Sheet 1

Monday, April 26,2004

Sheet 2

Tuesday, April 27, 2004

Sheet 3

Wednesday, April 28, 2004

Sheet 4

Thursday, April 29, 2004

Then the rest of the sheet be blank.

If somebody knows of a template out there like that let me know.

Thanks in advanced for any response.
 
Back
Top