+ Reply to Thread
Results 1 to 1 of 1

Vacation Accrual Linking Spreadsheet Formula

  1. #1
    Registered User
    Join Date
    Chicago, Illinois
    MS-Off Ver
    Excel 2010

    Vacation Accrual Linking Spreadsheet Formula

    The company I work for has a spreadsheet that details each employee's vacation time. The spreadsheet is set up like the attached (Vacation_1), spreadsheet. In columns A and B it lists the date (i.e. 23-Dec-12) and Day of the week (i.e. Sunday) respectively. In columns C and D it lists the Vacation and Personal time that each person has used for that two week period (vacation and personal time is accrued every two weeks based upon how long that person has been with the company). For example, on the attached spreadsheet Employee two used 8 hours of personal time on 28-Dec-12.

    The spreadsheet continues like this for the entire calendar year with our HR administrator updating the spreadsheet when employees take time off. My problem is that this spreadsheet is protected and very few people have access to it. I need to create a spreadsheet that links to this sheet and pulls each employee's data. I would like to set up a separate spreadsheet that lists:

    Employee Name:
    Beginning Balance as of (Date):
    Time Accrued (up to today's date):
    Time Taken (up to today's date):
    Balance (As of today's date):

    Is there a formula I can use to do this? Or does anyone have any suggestions about how I should solve this problem? I'll admit I'm pretty much a novice when it comes to Excel and any help would be greatly appreciated. Thanks.
    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)


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