+ Reply to Thread
Results 1 to 5 of 5

2020 Vacation Tracker

  1. #1
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    2020 Vacation Tracker

    Hello,

    Is there a way to add carry over days from 2019 for each employee on the attached 2020 leave tracker?

    Thanks,
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2003, 2010, 2016, 2019, & Office 365
    Posts
    194

    Re: 2020 Vacation Tracker

    Hi,

    I'm not entirely sure which values you are looking to accumulate.

    Why not create separate tabs for each year? It would be easier to pull in that data.

  3. #3
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181
    Quote Originally Posted by Rick-O-Shay View Post
    Hi,

    I'm not entirely sure which values you are looking to accumulate.

    Why not create separate tabs for each year? It would be easier to pull in that data.
    I just need to bring in each employees left over vacation time from 2019. So let’s say employee1 has 5 days from 2019 and in 2020 has 15 days I want to show that they have 20 days available in 2020. Not sure how to build that into the file. Thanks

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: 2020 Vacation Tracker

    I believe that I found the website from which the Leave Tracker was downloaded. One of the questions asks about tracking leaves over multiple years and the answer was the same as the one given by Rick-O-Shay.
    Q: I need to track multiple years of leaves. Do I need to create a new worksheet for each year (financial year)?
    A: Yes! This leave tracker can only track leaves for a 12 month period. You need to create a copy for each year.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Re: 2020 Vacation Tracker

    Thanks, I was trying to see if there was way to add a column to show carry over days from a prior year and then to edit the macro to pick up that column. In other words, at any given time we need to know how much time an employee has available without having to refer to multiple sheets or workbooks. Does that make sense?

+ 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. Seniority Vacation Tracker and Calendar
    By rjerand in forum Excel General
    Replies: 6
    Last Post: 10-18-2019, 08:04 AM
  2. Vacation Accrual Spreadsheet Tracker
    By melissap21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2019, 05:44 PM
  3. [SOLVED] Need to create a vacation tracker for 350+ employees
    By bethnee641 in forum Excel General
    Replies: 11
    Last Post: 11-12-2018, 01:53 AM
  4. Replies: 1
    Last Post: 04-29-2017, 01:06 AM
  5. Vacation Accrued/Used tracker sheet
    By busymom78 in forum Excel General
    Replies: 1
    Last Post: 06-18-2014, 04:52 AM
  6. [SOLVED] Re: Date Vacation Tracker
    By tls in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2006, 08:45 PM
  7. Looking for a vacation tracker
    By GeorgieP in forum Excel General
    Replies: 0
    Last Post: 07-21-2005, 02: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