+ Reply to Thread
Results 1 to 2 of 2

attendance spreadsheet

  1. #1
    Registered User
    Join Date
    01-01-2008
    Posts
    1

    attendance spreadsheet

    Hi everyone...

    I have adopted an attendance trcking spreadsheet from MS Online Templates.

    I have individual tabs for each person, and at the bottom of each persons worksheet has absences by month totals.

    Each employees tab has their month totals in the same cell....G119 is january absences, H119 february, etc....

    My summary page of all employee absences is not updating as I am not sure what formula to use. Any ideas on how I can select G119 from all worksheets and keep the formula working if I add a new employee.

    Thanks in advance!

    Here is the template I am using....
    http://office.microsoft.com/en-us/te...CT101425551033

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Links should help

    http://exceltips.vitalnews.com/Pages...orksheets.html

    http://www.rondebruin.nl/linksum.htm

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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