+ Reply to Thread
Results 1 to 8 of 8

Auto change date for printing

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    20

    Auto change date for printing

    Hi Guys,

    Is it possible if I have to print the same document for every day of the year. For excel to change the date as it prints out all 365 sheets.

    Only the date will change for each page.

    thanks in advance for your time.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Auto change date for printing

    Hi,

    Yes, just include the =TODAY() function wherever you want the date to appear.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-18-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Auto change date for printing

    Quote Originally Posted by Richard Buttrey View Post
    Hi,

    Yes, just include the =TODAY() function wherever you want the date to appear.
    Hi mate, not sure how this is inputted. So, basically if I press 61 prints each page will have the dates in order for 2 months?

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Auto change date for printing

    Hi,

    Maybe I'm misunderstanding you.
    I read your post as wanting to print out one sheet each day (hence 365 over the course of a year) and each time you print the document would contain the current day's date.

    If you mean something different then please clarify.

  5. #5
    Registered User
    Join Date
    03-18-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Auto change date for printing

    Quote Originally Posted by Richard Buttrey View Post
    Hi,

    Maybe I'm misunderstanding you.
    I read your post as wanting to print out one sheet each day (hence 365 over the course of a year) and each time you print the document would contain the current day's date.

    If you mean something different then please clarify.
    What I meant was, pressing print 'once' and every sheet that comes out of the printer will be a date greater than the next piece of paper.

    So if I press print every page will be exactly the same, except each print will increase the date by one day.

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Auto change date for printing

    ... and when you say 'sheets' do you mean that you have 365 Excel sheet tabs, or do you mean that you have a range on a single sheet with 365 page breaks (either manual or automatic) which prints 365 'sheets'

  7. #7
    Registered User
    Join Date
    03-18-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Auto change date for printing

    Quote Originally Posted by Richard Buttrey View Post
    ... and when you say 'sheets' do you mean that you have 365 Excel sheet tabs, or do you mean that you have a range on a single sheet with 365 page breaks (either manual or automatic) which prints 365 'sheets'
    I mean, I have an excel register, one sheet, one tab. But what i want to do is print off a years worth of the same sheet, from 1st Jan to 31 Dec.

    What I am currently doing is 01 Jan 2014 then press print, 02 Jan 2014 then press print (365 times). Can excel understand that I want just the date changed on the sheet for every day of the year?

    I press print and I get the same sheet 365 copies, with every date of that year in order.

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Auto change date for printing

    Hi,

    OK then what you need is a simple macro that will increment the date every time it sends the print page instruction to the printer.

    Something like the following

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto Increment Date on printing
    By Bealesy1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2015, 11:13 PM
  2. need to change date of sheet after printing
    By eyesonly1965 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2012, 08:52 AM
  3. Replies: 3
    Last Post: 05-17-2011, 09:44 AM
  4. Replies: 2
    Last Post: 08-06-2005, 08:05 AM
  5. Auto Date range and printing.
    By Houm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2005, 01:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1