create a day planner and print a whole year

[paulyd04]

Alright guys. My boss has these single day spreadsheets he likes to use- 1 for everyday. Essentially it breaks down the day by hour and then has a below section for notes. Normally what I do is just print out a single date, then manually change the date by typing in the next day and print it out too. I normally do a month at a time, but it's extremely time consuming and I know that excel has a quicker way to do this. So far i've figured out the formula to display the day of the week and also display the today date in full format (month, day, year) So what I was wondering if I could do this...

1. Is there a way to use some kind of autoprint function that would allow me to print a year's worth of sheets from a single sheet that displays the current date and the only thing that would change from sheet to sheet would be the day of the week and the date.

2. Also- when it autoprints is there anyway to skip sundays so it would only print monday-saturday?

[Palmetto]

Lacking sufficient details about the structure of your sheet, here is a start that you can adapt.

Please Login or Register  to view this content.

[paulyd04]

ok so where in excel do i put all that code? i'm not too excel literate so could you tell me also how to use that code

[JBeaucaire]

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.