Increment date on printing each page

**HAPPYHILARY** · 07-13-2009, 07:01 AM

Wise Old Owl...

Sorry - just to clarify ....

I print one months worth of safety check sheets in one go ... so when I send it to the printer can Excel create a different date on each page???

Thanks for your time.

Hilary

**oldchippy** · 07-13-2009, 07:55 AM

Hi,

To do that you would need a macro, but if you want a workaround you could go to File > Page Set up > Header/Footer, click Custom Header in the left section type July and a single space, then click on Page number icon (2nd one). Then when printed each new page is "dated". Obviously you would need to edit it for each month. does that work for you?

**Palmetto** · 07-13-2009, 09:10 AM

OldChippy,

Slick trick - I like it!

**HAPPYHILARY** · 07-13-2009, 11:19 AM

I agree with Mr South Carolina! ... very slick.
Thank you - will try it when I go into work.

The Macro you mention ..... is it complex?
If not I'd like to have a go at it if you wouldn't mind pointing me in the right direction.

Much appreicated,
Hilary

**Palmetto** · 07-13-2009, 11:39 AM

My recommendation is to avoid the macro as the work-around Oldchippy provided is more efficient as it is built-in to Excel.

**HAPPYHILARY** · 07-26-2009, 05:08 PM

Sorry wise Chippy - doesn't seem to work past page 2.
Need it for the whole months worth.
I've attached the document - if you have the time would you have a look
please.
Thanks
Hilary

**oldchippy** · 07-27-2009, 08:25 AM

Originally Posted by HAPPYHILARY

Sorry wise Chippy - doesn't seem to work past page 2.
Need it for the whole months worth.
I've attached the document - if you have the time would you have a look
please.
Thanks
Hilary

Hi HAPPYHILARY,

You're right it doesn't work for you with this one. From your question I was thinking that each tab was on one page and you had 31 tabs for a month, in which case it would have done, but it looks like Martin's been working hard to find you a solution.

**davebozy** · 12-12-2010, 11:20 PM

I'm trying to do the same thing but I need 6 months in advance and need the day of week included. Is that possible?

**mrverd** · 03-03-2015, 10:34 PM

Can you create something that allows me to pick dates to print?

Increment date on printing each page

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Increment date on printing each page

Re: Increment date on printing each page

Re: Increment date on printing each page

Re: Increment date on printing each page

Re: Increment date on printing each page

Re: Increment date on printing each page

Re: Increment date on printing each page

Re: Increment date on printing each page

Re: Increment date on printing each page

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions