Making a transportation sign up sheet?

October 25, 2012 at 19:48:22
Specs: Windows xp

I need to make a appointment book for a transportation department. I have to have a sheet that has the day of the week, the month, date and year for every day of the month. Example Thursday, October 25, 2012, Friday, October 26, 2012etc. Is there a program that would print out a page for each day of the month like this?

See More: Making a transportation sign up sheet?

Report •

October 26, 2012 at 11:22:46
I'm not sure what you are asking for.

Are you asking for a months worth of sheets with just the date on each one or do you have some kind template with other information on it and you want a copy of that template for each day of the month?

The more specifics you provide, the better a solution we can offer.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

October 26, 2012 at 11:31:57
Most Excel software comes with standard templates already installed one
of which I believe is a Calendar.

What version of Excel are you running?

On 2007:

Click the Microsoft Office button
Click New

A New Workbook window should pop up with a list of available templates,
select the calender template and see if it fits your needs.

If not, search the web for an Excel Calendar Template, you should
get a lot of hits.


Report •

October 26, 2012 at 20:17:17
HI Again

I need to make a sign up log that will be in a big 3 ring notebook. The main title will be Private Transportation sign up with the date. Other heading will be name, apartment number, address. pickup time, and appointment time. EACH DAY OF THE MONTH NEEDS ITS OWN SHEET WITH DATE. So the month of October will need 31 sheets with a separate date. I dont want to write everyday and date by hand. Im looking for a program that will spit out 31 sheets with day and dates.

So each page will look like this Monday October 22, 2012
next sheet Tuesday October 23,2012
next sheet Wednesday October 24 2012

I hope this kinda cleared things up. Im going to be using excel 2003

Report •

Related Solutions

October 27, 2012 at 07:44:30
I think what you really want is a way to print out a blank sheet,
with the date Increment on each page, correct?

If yes, then what you really need is a macro,
but unfortunately my macro skills are just above nil.

But here is a workaround to play with:

Go to File > Page Set up > Header/Footer,
Click Custom Header

Now in the left section type October and a single space,
Next click on the Page number icon should be the 2nd one.
If you wish, add the year after the Page Number icon.

Now, when printed each new page is "dated" with an incremented date
starting at 1.

Just remember that you need to edit it for each month.

See how that works for you.


Report •

October 27, 2012 at 20:40:26
HI Mike

Im afraid it didnt work. It just printed one page with the date. I was kinda hoping it would spit out 31 pages each with a separate day, date etc. Any ideas?


Report •

October 27, 2012 at 21:09:27
Where do you want the date to be on each sheet? In what cell?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

October 28, 2012 at 07:34:13
Try this,

When you Print, there should be a Number of Copies Box
put 31 or 5 or some number and see how that works, but like I said what you need is a
macro to really get what you want.


Make sure you have the right Page Icon,
it should look like &[Pages] << note the S, plural.


Report •

October 28, 2012 at 10:57:15
Here is another (Untested) work around:

Put your Date in cell A1,
Next, Select, highlight, the Range of Cells A1 thru A47
Now at the lower right corner of your selected range,
there is a small box, grab the box and Drag down to Row # 1411.

You should now have a Date every 47 Rows,
IE Cell A1, Cell A48, Cell A95

As it happens, that is the number of rows that
print on a Portrait Orientation, Letter Size paper,
with default margins. (On Excel 2007)

So you should get what your looking for.

If you prefer to use Landscape Orientation, to give you more room,
then use the Range of Cells A1 thru A34

But, if you answer DerbDad03's query, you will get a macro
that will be more suitable and a lot easier to use.


Report •

October 28, 2012 at 11:20:04
OK, last workaround,

Enter your first date in Cell A1
Drag down 30 cells, you should now have
the complete month.
Next, select your first date, in cell A1
Scroll to the Insert tab on the command bar
select Page Break and insert a page break.
Do that for each day of the month.
Now Print.


Report •

Ask Question