+ Reply to Thread
Results 1 to 2 of 2

Using Macro to Print Multiple Dates From One Worksheet

  1. #1
    Registered User
    Join Date
    03-10-2017
    Location
    Michigan, United States
    MS-Off Ver
    2013
    Posts
    1

    Using Macro to Print Multiple Dates From One Worksheet

    I need to print a month's worth of sign in sheets for my employees. Instead of writing out each date by hand at the top of each page, I'd like to be able to print consecutive dates from one worksheet. To my knowledge, I will have to use a macro or VBA workbook (?) for this, but I have never used macro. I know how to access it and where to put in the code, but I'd like someone to post a macro sequence for me and then explain it to me or tell me if I need to add anything to it myself.

    Thank you!
    Last edited by jmulder; 03-13-2017 at 09:10 AM.

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Using Macro to Print Multiple Dates From One Worksheet

    Hi
    this should get you started. It gives you an input box asking for the date of the first letter, then puts that date into cell A1, increased the date by one day, and repeats this to the end of the month. It doesn't account for weekends but could be tweaked if your staff don't work them.

    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. Print Multiple Worksheet Print Macro
    By cbjfan2009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2015, 12:35 PM
  2. Macro to print multiple print areas on one page.
    By morangeman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2015, 12:13 PM
  3. Print multiple ranges on worksheet to one file
    By amalejko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2014, 02:25 PM
  4. Replies: 3
    Last Post: 05-26-2014, 02:21 AM
  5. [SOLVED] Print same page, multiple times based on dates entered
    By DixieLou in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2014, 04:32 PM
  6. [SOLVED] Request a Macro to Convert data into Dates (Multiple Dates Values separated by Line)
    By seenai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2012, 02:28 AM
  7. [SOLVED] Macro to print the current worksheet WITHOUT having Print Preview
    By terrydennis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2012, 11:00 AM

Tags for this Thread

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