+ Reply to Thread
Results 1 to 4 of 4

Need help auto-populating sequential dates on tabs in 00-00-0000 form

  1. #1
    Registered User
    Join Date
    09-16-2020
    Location
    Clinton
    MS-Off Ver
    2008
    Posts
    5

    Need help auto-populating sequential dates on tabs in 00-00-0000 form

    This is an age old problem for me. I try to do this every month that I start a new workbook. I usually give up and do it manually.

    I have a master workbook of 31 tabs that I copy each new month. All I want to do is auto-populate the sequential date on each tab in 00-00-0000 form. Can anyone post a VBA that I can use to update the existing master?
    Last edited by LynnPeterson; 09-16-2020 at 03:39 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Need help auto-populating sequential dates on tabs in 00-00-0000 form

    Where do you want the date to go?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    09-16-2020
    Location
    Clinton
    MS-Off Ver
    2008
    Posts
    5

    Re: Need help auto-populating sequential dates on tabs in 00-00-0000 form

    Attachment 695587

    Its just on the tabs that I have trouble. I have gotten it to work before, but not in this format.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Need help auto-populating sequential dates on tabs in 00-00-0000 form

    Do you mean you want to name the sheets with the dates of the current month?

    Are there only 31 sheets in the workbook?

    What should happen if there are less than 31 days in the month?
    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. (Solved) Converting a date from 00/0000 to 00/00/0000
    By RigbyDigby in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-11-2019, 07:34 PM
  2. How to auto-populate sequential dates on multiple tabs?
    By natureExcel in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-29-2016, 10:31 AM
  3. Creating Date Tabs using dates entered via form
    By MartinF123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2014, 06:34 PM
  4. "Sequential dates across tabs"
    By dreamingscott in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2014, 07:28 PM
  5. [SOLVED] Sequential Dates on Form Excluding weekends
    By jbmerrel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2013, 03:04 PM
  6. Replies: 4
    Last Post: 06-23-2005, 08:05 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