Autodate sheets for a specified date range

[Scott Whetsell, A.S. - WVSP]

I have a workbook with four sheets. Each sheet needs to be dated. Currently
I have sheets 2, 3, 4 referenced to sheet 1, but I have to type in each date
one at a time. I would like to know if it is possible to set it up so that
it will prompt me for a date range, similar to that of the calendar template
for Word, and will take the date range that I give it and print out all four
sheets dated for each of the dates in the range. I am not sure if this is
too complicated for Excel to handle.

Ex. The forms that we use we print for a month at a time. Currently I have
to open the workbook, and type in the date, tell it to print the sheets, then
change the date, etc., until all the dates that I need have been typed and
printed.

I am looking for a way to specify a date range such as October 2004, that it
will accept, realize that there are 31 days, and print out each sheet in the
workbook dated for each of the 31 days. The date format that I am currently
using is MM/DD/YY.

 

[Don]

Hi Scott,

I'm sure someone will come along with some VBA to do this
for you or a better way to do it with formulas but this
will work....just take a little time to set up.

In A1 Sheet1 manually enter the date in the format you'd
like.

In A1 Sheet2 format the same...enter this:

=Sheet1!A1+1

In A1 Sheet3 format the same...enter this:

=Sheet1!A1+2

and so on for all the sheets you require.

This will determine the number of days in the month and
advance to the correct month correctly.

Probably a much better way of doing this, but this will
work.

HTH,

Don

 

[Don]

Hi Scott,

If you want all your sheets to have the same date as you
enter on Sheet1, group all Sheets together except Sheet1
and enter "=Sheet1!A1"...then be sure to ungroup the
sheets. Whatever you enter in Sheet1 A1 will appear in
all the sheets.

Is this what you're looking for?