+ Reply to Thread
Results 1 to 3 of 3

User enter start & end date - print sheet with start date, update 1, print sheet

  1. #1
    Registered User
    Join Date
    04-10-2019
    Location
    Fenwick Isand, Delaware
    MS-Off Ver
    7 Professional
    Posts
    5

    User enter start & end date - print sheet with start date, update 1, print sheet

    I have a brain freeze. I need to have a user enter a start date and end date in two designated cells in the active workbook. I need to have a macro that will put the start date in cell C1, print a range A1:H55, increment the date by one day, write it in cell C1, print the range and loop until the end date.

    Thanks for the assist!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: User enter start & end date - print sheet with start date, update 1, print sheet

    Assuming start and end dates are resp. in J1 and J2 cells try such code:

    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    04-10-2019
    Location
    Fenwick Isand, Delaware
    MS-Off Ver
    7 Professional
    Posts
    5

    Re: User enter start & end date - print sheet with start date, update 1, print sheet

    Thanks - it's perfect!

+ 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. [SOLVED] Userform Start and End Date Populating Results Sheet
    By azscootergirl in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-08-2018, 04:56 PM
  2. Replies: 1
    Last Post: 08-07-2016, 11:13 PM
  3. Replies: 3
    Last Post: 06-23-2015, 09:56 AM
  4. Replies: 0
    Last Post: 07-03-2012, 03:52 PM
  5. Take user input start date and end date. Create a column for each month between these
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2010, 11:46 AM
  6. Chart with Editable Date Range (user specified start date)
    By fateshand in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-12-2009, 05:03 AM
  7. Macro to Print Update and Print Sheet
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2007, 11:10 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