+ Reply to Thread
Results 1 to 7 of 7

Auto Updating sign-in roster

  1. #1
    Registered User
    Join Date
    12-15-2008
    Location
    East Texas
    Posts
    40

    Auto Updating sign-in roster

    I love coming here because the Kung-Fu is strong here. So I have to make sign in rosters for everyday of the month. I usually print them 30 days at a time and I keep changing the day and print. this eats up all of my time. What I want to do it be able to print for a entire month (1 per Day)without having to manually change the dates. I have included a general example. Any help would be great. Thanks
    Attached Files Attached Files
    Last edited by SavageMind; 06-19-2017 at 01:03 PM.

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,654

    Re: Auto Updating sign-in roster

    Something like this
    Put the first date in cel A1
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    12-15-2008
    Location
    East Texas
    Posts
    40

    Re: Auto Updating sign-in roster

    Thanks, But it is not quite what I'm looking for. I decided to make 31 tabs. I used a Formula =DATE(2017,7,1) Each sheet I added a number so the formula for July 2nd would be
    =DATE(2017,7,1)+1. I'm hoping to be able to select all the tab and change the month one time. This is not a good fix as it can bring a higher rate of error if I have to change each month by one for each tab. Thanks for the help. Still not solved but closer from where I was.
    Attached Files Attached Files
    Last edited by SavageMind; 06-19-2017 at 01:01 PM.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,654

    Re: Auto Updating sign-in roster

    Please update a more accurate file

  5. #5
    Registered User
    Join Date
    12-15-2008
    Location
    East Texas
    Posts
    40

    Re: Auto Updating sign-in roster

    It is updated.

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,654

    Re: Auto Updating sign-in roster

    ='Day 1'!A2+1
    Try this formula for Day 2

  7. #7
    Registered User
    Join Date
    12-15-2008
    Location
    East Texas
    Posts
    40

    Re: Auto Updating sign-in roster

    So I did Fix it. I am including a generic version for people to use with instructions. Thanks for the help.
    Attached Files Attached Files

+ 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. Roster Auto Pattern
    By dineshsachidananda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2016, 12:15 AM
  2. Roster Auto Calculation
    By firsttimer in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-02-2015, 02:04 PM
  3. Vehicle Sign Out Log - Auto Save, Auto Date & Time
    By ccalangi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2015, 09:16 AM
  4. Vehicle Sign Out Log - Auto Save, Auto Date & Time
    By ccalangi in forum Excel General
    Replies: 0
    Last Post: 01-21-2015, 09:16 AM
  5. Excel 2007 : Auto complete shift roster
    By What's it doing in forum Excel General
    Replies: 1
    Last Post: 06-08-2012, 01:33 AM
  6. Auto Generating Employee Roster
    By williamwwise in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2011, 01:28 PM
  7. Auto populate data for Roster
    By lordfa9 in forum Excel General
    Replies: 3
    Last Post: 03-29-2010, 09:18 AM

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