Connecting Worksheets

Giganews Newsgroups
Subject: Connecting Worksheets
Posted by:  czbacn…@gmail.com
Date: 2 May 2006

Hello!

I have an excel document that calculates vacation hours. Each pay
period, employees accumulate (how much depends on how long they have
been employed here) their: Earned hours, Used hours, and finally Total
hours left. The worksheet is set up:

            4/20/06    4/20/06    4/20/06      5/5/06      5/5/06
5/5/06
            Earned      Used        Total        Earned      Used
  Total
Name
Name
Name

Employees would like another excel sheet to show them thier current
Total. (It doesn't matter if all employees are on the same sheet) I am
wondering how on another sheet I can ensure that it always shows the
current total (not from previous pay periods). I know how to connect
worksheets, but what formula do I use to show the most current data?

Any suggestions would be very much appreciated :)

Thanks,

Carla

Replies